home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Business Master (3rd Edition)
/
The Business Master (3rd Edition).iso
/
files
/
busition
/
dayosup2
/
dayoscd.exe
/
DAYOSC.DOC
< prev
next >
Wrap
Text File
|
1992-06-25
|
399KB
|
4,968 lines
╔════════════════════════════════════════════════════════════════════════════╗
║ ║
║ ██▄█████████▄ ▄█▄ ███ ███ ▄███████████▄ ║
║ ███ ███ ▄█████▄ ███▄ ▄███ ███ ███ ║
║ ███ ███ ███ ███ ▀███ ███▀ ███ ███ ║
║ ███ ███ ███ ███ █████ ███ ███ ║
║ ███ ███ ▄███████████▄ ███ ███ ███ ║
║ ███ ███ ███ ███ ███ ███ ███ ║
║ ██▀█████████▀ ███ ███ ███ ▀███████████▀ ║
║ ║
║ ██████ ██ ██ ██▄███ ██▄███ ▄████▄ ██▄███ ██████ ║
║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║
║ ██████ ██ ██ ██████ ██████ ██ ██ ██████ ██ ║
║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║
║ ██████ ██████ ██ ██ ▀████▀ ██ ▀██ ██ ║
║ ║
║ ██████ █ ██ ██ ██████ ║
║ ██ ███ ██ ██ ██ ║
║ ██ ██ ██ ██ ██ ██████ ║
║ ██ ███████ ██ ██ ██ ║
║ ██████ ██ ██ ██████ ██████ ██████ ║
║ ║
║ ██ ██ █ ██ ██ █ ██████ █████ ██ ██ █████ ██ ██ ██████ ║
║ ███ ███ ███ ███ ██ ███ ██ ██ ███ ███ ██ ███ ██ ██ ║
║ ████████ ██ ██ ██████ ██ ██ ██ ███ ████ ███████ ████ ██████ ██ ║
║ ██ ██ ██ ███████ ██ ███ ███████ ██ ██ ██ ██ █ ██ ██ ██ ███ ██ ║
║ ██ ██ ██ ██ ██ ██ ██ ██ ██████ █████ ██ ██ █████ ██ ██ ██ ║
║ ║
║ ██████ ██ ██ ██████ ██████ █████ ██ ██ ║
║ ██ ██ ██ ██ ██ ██ ███ ███ ║
║ ██████ ████ ██████ ██ ████ ███████ ║
║ ██ ██ ██ ██ ██ ██ █ ██ ║
║ ██████ ██ ██████ ██ █████ ██ ██ ║
║ ║
║ Copyright (c) 1991 - 1992, TJS LAB Inc. ║
║ 5104 North Orange Blossom Trail, Ste 200, Orlando, FL 32810 ║
║ ║
║ ██████ ▀███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ S H N ║
║ ▀ ██ ▀ ████ ▀▀▀▀▀███████████████████████████▌ O A E ║
║ ██ ██ ▄███▄ ▀████▀▀ ▀████████████ F R T ║
║ ██ ██ ██ ▀ ▀▀ ███████████ T D W ║
║ ██ ▄ ██ ▀███▄ Specializing In ▐█████████▌ W W O ║
║ ▀███▀ ▄ ██ MicroComputer & Network ██████████ A A R ║
║ ▀███▀ Solutions & █████*████▌ R R K ║
║ Applications ▐███████████ E E S ║
║ ▀██ █ ▀█▄███▄ ┌─┐ ┌─┐ ███████████▌ ║
║ ██ █▀█ ██ ██ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ Custom: ║
║ ██ ▄█ █▄ █████ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ Programs ║
║ ██ ██▄██ ██ ██ ▐▀▌ └───╜ ▐▀▌ ███▄▄███ Reports ║
║ ████ ▄█ █▄ █▀███▀ █████ ▐▀▌ █████ ▀█████▌ Routines ║
║ █████ ▀▀▀█ Forms ║
║ Incorporated █ ║
║ ▄▄▄▄▀ ║
╠════════════════════════════════════════════════════════════════════════════╣
║ Support: (407) 291-3960 Sales: 292-4708 Fax: 295-2171 BBS: 292-4921 ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, INC.
■ SOFTWARE SUPPORT POLICY
1. TJS LAB does not support users of unregistered DAYO products with the
exception of installation questions.
2. Support (included with registration) remains in effect for 3 months
after date of registration or purchase.
3. Support is available through the following methods:
- Limited Phone Support: (407) 291-3960 9am to 5pm M-F
- U.S. Mail: TJS LAB, Inc., PO Box 585366, Orlando, FL 32858-5366
- Compuserve Easyplex: 76367,1401
4. Any errors ("bugs or features') in the program will be corrected and
the 'fix' sent promptly (via modem if possible).
DAYO SC, Copyright(c) 1992 TJS LAB, INC.
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
1......INTRODUCTION
2......COPYRIGHT/LICENSE
2......DISCLAIMER
2......REQUIREMENTS
2......SETUP
3......DATA (DATABASE) FLOW
4......DAYO SC 'RULES'
5......MAIN MENU
6...... EXIT
6...... EDIT CURRENT SUPPORT CALL RECORD
7......SELECT INCOMING PHONE CALL
7......CLOSE CURRENT SUPPORT CALL
8......EDIT SUPPORT CALL/INCIDENT NOTES
8......RUN MENU
9...... EDIT MENU RECORD
9...... ADD MENU RECORD
10......REPORTS
10...... REPORTS LISTING
11...... PRINTER SETUP/DRIVER
11...... PRINTER DRIVER OPTIONS
12...... CHANGE DEFAULT PRINTER
13...... FULL SCREEN EDIT - PRINTER DRIVER
13...... PRINTER DRIVER DATABASE FIELD DEFINITIONS
14...... PIN LIST
18...... PIN LABELS
19...... PIN PHONE LIST
20...... EXPANDED PIN REPORT
21...... PIN USAGE & HISTORY REPORT
22...... OPEN INCOMING PHONE LOG LISTING
22...... OPEN SUPPORT CALLS REPORT
23...... CALL LOG (HISTORY) REPORT
23...... CATEGORY #1 PROBLEM LISTING
24...... CATEGORY #2 PROBLEM LISTING
24...... RESOLUTION LISTING
24...... CATEGORY #1 PROBLEM LISTING
25...... CUSTOMER BILL TO ADDRESS LABELS
26...... CONFIGURATION STATUS REPORT
26...... EXAMPLE OF A CONFIGURATION STATUS REPORT
27...... CALCULATOR
27...... VIEW REPORTS ON SCREEN
29...... REPORT VIEWING SCREEN
30......BROWSE OPEN SUPPORT CALLS/RECORDS
31...... FULL SCREEN EDIT - OPEN SUPPORT CALL RECORD
32...... EDIT SUPPORT CALL/INCIDENT NOTES
DAYO SC, Copyright(c) 1992 TJS LAB, INC.
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
33...... ADD SUPPORT CALL/INCIDENT RECORD
33...... FIND PIN RECORD WHILE CREATING A NEW SUPPORT CALL RECORD
34...... FAST FIND PIN WHILE CREATING A NEW SUPPORT CALL RECORD
35...... FIND INCIDENT/SUPPORT CALL RECORD
36......BROWSE PIN DATABASE
37...... FULL SCREEN EDIT - PIN RECORD
37...... FIND PIN RECORD
38...... FAST FIND PIN
39...... EDIT PIN NOTES
40......BROWSE HISTORY OF SUPPORT CALLS DATABASE
41...... FULL SCREEN EDIT - HISTORY SUPPORT CALL/INCIDENT RECORD
42...... EDIT HISTORY SUPPORT CALL/INCIDENT NOTES
42...... FIND HISTORY SUPPORT CALL/INCIDENT RECORD
43......BROWSE CUSTOMERS
44...... ADD A NEW RECORD - FULL SCREEN EDIT
44...... FIND CUSTOMER RECORD
46......SUPERVISOR OPTIONS (CONFIGURATION)
46...... CONFIGURATION LISTING
47...... COMPANY NAME
47...... COMPANY ADDRESS
47...... COMPANY TELEPHONE
47...... LAST REFERENCE NUMBER
48...... ALLOW CUSTOMER ADD
48...... CUSTOMER DATABASE LOCATION/DIRECTORY
49...... 'RAW' PHONE LOG DATABASE LOCATION/DIRECTORY
49...... CURRENT DIRECTORY DATABASE LOCATION
50...... BROWSE PROBLEM CATEGORY #1
50...... FULL SCREEN EDIT - CATEGORY 2 RECORD
51...... BROWSE PROBLEM CATEGORY #2
51...... FULL SCREEN EDIT - CATEGORY 2 RECORD
52...... BROWSE RESOLUTION DATABASE
52...... FULL SCREEN EDIT - RESOLUTION RECORD
53...... EDIT SERIAL NUMBER CODES
53...... EDIT NOTES - SCREEN MODE: 25, 43 (EGA), or 50 (VGA) LINES
54...... ASSIGN PIN BLOCKS/NUMBERS
55...... BROWSE 'RAW' PHONE LOG DATABASE
56...... FULL SCREEN EDIT - VRU/LOG.DBF RECORD
57...... DEFAULT EXCLUDED MAIN MENU OPTIONS (USED WITH PASSWORDS)
57...... USE PASSWORDS
58...... PASSWORDS MAINTENANCE
58...... EDIT/ADD PASSWORD
59...... NOVELL NETWORK & PASSWORDS
60...... GLOBAL PACK & REINDEX
DAYO SC, Copyright(c) 1992 TJS LAB, INC.
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
61...... MISCELLANEOUS ROUTINES
61...... MISC ROUTINES MENU:
62...... APPEND FROM
64...... BROWSE DATABASES
66...... COPY (.DBF) TO
68...... CREATE DATABASE
70...... DELETE RECORDS
71...... ERASE FILE
71...... EXIT TO DOS
72...... INDEX A DATABASE
73...... LIST FIELDS
76...... MODIFY DATABASE
77...... PACK DATABASE
78...... RECALL RECORDS
78...... RETURN TO MENU
78...... RUN (DOS COMMAND)
79...... SIMPLE EDITOR
80...... SORT DATABASE
81...... TYPE (PRINT) FILE
82...... ZAP DATABASE
84...... SCREEN FONTS
84...... SYSTEM
85...... REPORT PRINTER PORT
85...... AUTOMATIC DAILY INDEXING
85...... COLOR MONITOR
85...... COLOR INTENSITY
86...... CREDITS
87......REINDEX ALL DATABASES
87......AVAILABLE MEMORY
88......HELP SCREENS
89...... EXPANDED HELP
90...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
91...... VIEW DOCUMENTATION ON SCREEN
92......DATABASE STRUCTURES
99......DATA DICTIONARY
104......TJS 'COMPUTER' LAB INC
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 1
■ INTRODUCTION
DAYO Support Call Management System (SC) gives you the platform for
managing all your support and/or service calls. It is by default a
multiuser system, allowing almost unlimited numbers of users to have the
ability to simultaneously access the same data on a PC based LAN/Network,
ie: Novell (tm) and LANtastic (tm).
Options, features and reports include: Printer Setup, PIN List,
PIN Labels, PIN Phone List, PIN Expanded Report, PIN Usage/History Report,
Open Call Log List, Daily Call Log Report, Incident/Support Call Log Report,
Category #1/Problem List, Category #2/Problem List, Resolutions List,
Customer List, Customer Labels, Configuration Status Report, Calculator,
View Reports On Screen, Company Name, Company Address, Company Telephone,
Last Reference Number, Allow Customer Add, Customer Location, Phone Log
Location, Current Directory, Browse Category #1, Browse Category #2, Browse
Resolutions, Serial Number Codes, Notes Screen Size, Assign PIN Blocks,
Browse Phone Log, Default Excluded Options, Use Passwords, Passwords
Maintenance/Browse, Global Pack & Reindex, Miscellaneous Database Routines,
Screen Fonts, System Statistics, Report Printer Port, Auto Daily Indexing,
Color or Mono Monitor, and High Intensity Color Setting.
Other DAYO Products:
DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving
DAYO Quotes Sales Quoting System
DAYO Price Books Special pricing for your customers as well as a wide
range of product catalogs/reports
DAYO AR Accounts Receivable
DAYO AP Accounts Payable
DAYO EOP End Of Period Posting
DAYO MRP Bill of Materials, Ship Orders
DAYO Job Costing Job/Work Order/Project Costing System
DAYO Smart Reports A variety of reports pertaining to the above modules
DAYO Payroll U.S. Payroll
DAYO Sales Mgmt Quotes, Calendar, Price Books and Contacts
System
DAYO Report Writer Relational Report (tm) Writer
and many more...
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 2
■ COPYRIGHT/LICENSE
This manual and software is copyrighted with all rights reserved by
TJS LAB. No copying of this manual or software is authorized without
the prior written consent of TJS LAB. An exception to this rule is the
making of backup copies of registered software disks. No RESALE of any part
of the source codes is authorized without the prior written consent of
TJS LAB. TJS LAB retains all rights to DAYO POS software, documentation,
and source codes.
Authorization to distribute Demonstration Versions is granted.
■ DISCLAIMER
No warrant is made that this software will work in all environments,
or with all resident programs and hardware configurations. TJS LAB has
tested this software in many environments and found it to perform as
expected, however, this software is licensed "AS IS".
TJS LAB will not be liable for any damage done to your data, hardware,
and/or software systems as a result of using DAYO SC.
■ REQUIREMENTS
IBM Compatible Computer with at least 20 megabytes of free disk space
(less required for Lap Tops). An AT class CPU is highly recommended
(286 or better).
640k base RAM with 520k free after DOS (and Networks) loaded
DOS 3.3 or above
Printer, preferably an HP Laser Printer (or compatible, all/any types),
but a Dot Matrix will be fine.
■ SETUP
To setup DAYO SC, use the SETUP program supplied on the MENU or
Update & Conversion diskette, or copy the contents of the DAYO SC
floppy disks into a directory on your hard disk (ie: \DAYOSC), then
'uncompress' (ie: PKunzip ) them. When running DAYOSC for the first time,
it will create all the database, index, and configuration files it requires
for operation. If other DAYO modules are being used, be sure to enter the
location of these databases into the DAYO SC configuration.
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 3
■ DATA (DATABASE) FLOW
╔═══════════════╗ ╔══════════════╗
║ Incoming ║ ║ Add (Ctrl N) ║
║ Support Calls ║ ║ Support Call ║
╚═══════════════╝ ║ or Incident ║
│ ╚══════════════╝
│ │
│ │
│ │
│ Add Record │
└────────┬─────────┘
│ ╔════════════════╗
│<─────────────────── ║ PIN ║
│ ║ Personal ║
│ ║ Identification ║
╔══════════╗ │ ║ Number ║
║ Customer ║ ──────────────────>│ ╚════════════════╝
╚══════════╝ │
│
│
│
│
╔═══════════════╗
║ Open ║ Maintenance/Edit
║ Support Calls ║ Support Call/Incident
║ & Incidents ║ ie: record problem and resolution
╚═══════════════╝
│
│
│ Close Support Call/Incident
│
│
╔═══════════════╗
║ History of ║
║ Support Calls ║
║ & Incidents ║
╚═══════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 4
■ DAYO SC 'RULES'
Customers records are for accounting uses. A customer record may have
many Personal Identification Number (PIN) records. You can not edit a
customer record, but you can elect to be able to add new records.
Every support call or incident must be assigned to a valid PIN.
'Incoming' support calls are only available to Voice Response Units (VRUs),
and usually take some customization by TJS LAB, Inc.
Support call records will be created (when you don't have a VRU), by
pressing Ctrl N while in the browse routine of Open Support Calls (Alt O).
Support calls/incidents stay open until you close them! A valid resolution
code must be selected before you can close a call/incident.
The first 5 digits of the PIN represent a single digit TYPE code, a 2 digit
Month and a 2 digit Year code (date PIN was created). The right 6 digits of
the PIN represent a numeric counter.
The serial number is actually the PIN, with the 1st 5 digits encrypted.
The serial number can be used on contracts, manuals and/or issued to the
PIN/users. Its use is totally optional.
There are PIN notes, support call/incident notes and customer notes. Each
of the notes is stored in a different database, and have significantly
different uses.
After a period of time (days or weeks depending on the number of records
you create), you need to perform a PACK. This process, located in the MISC
ROUTINES, will remove records marked for deletion. This process WILL corrupt
the indexes, so be sure to reindex after a PACK!
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 5
■ MAIN MENU
All major DAYO SC routines are accessed from the main menu. Unlike
earlier DAYO modules, this menu is displayed at the bottom of the screen,
accessed by function keys or the arrow keys.
All major routines are accessed from the main menu of DAYO SC. These
routines include: Read User Manual On Screen, Edit Current Open Support Call
Record, Select Incoming (New) Support Call (generated by your VRU), Close
Current Support Call, Edit Current Support Call Notes, Run External Program,
Reports Menu, Select From Open Support Calls, Browse PIN Database, Browse
Past (Closed) Support Call Records, Browse Customer Database, Supervisor
Options & Configuration, Reindex All Databases and Display Available Memory.
DAYO SC Version 4.00 TJS LAB, Inc. ┌────[June 1992]─────┐
Copyright (c) 1992 All Rights Reserved │S M T W T F S │
██▄███░ ▄███▄ ██░ ██░ ▄███▄ ▄████░ ▄████░ ├────────────────────┤
██░ ██░ ██░██░ ██░ ██░ ██░██░ ██░ ██░ │ 1 2 3 4 5│
██░ ██░ ██░██░ ▀████▀ ██░██░ ▀███▄ ██░ │ 6 7 8 9 10 11 12│
██░ ██░ ██▀▀▀██░ ██ ██░██░ ██░ ██░ │13 14 15 16 17 18 19│
██▀███░ ██░ ██░ ██░ ▀███▀ ████▀ ▀████░ │20 21 22 23 24 25 26│
┌───────────────────────────────────────────────────────┤27 28 29 30 31 │
│ User System Manager Time On 12:39:42│ │
└───────────────────────────────────────────────────────┴─────┤12:40:04├─────┘
Name Montgomery Sally Started 12:01:01 Reference 100012
Comment
Problem DAYO Inventory Network - LANtastic
Resolution Fixed Immediately PIN 21091006002 CBAJB006002
Start Date 10/15/91 End Date 12/01/93 Days Remaining 778 Calls 54
Address 4409 Beaumont Drive DOB 08/18/57 SSN 399-99-9999
Building 400 UF1 Printers UF2
City/ST/Zip ORLANDO FL 32810-0001 Call Limit 202
Phone 1 (407) 292-4708 Phone 2 (407) 291-3960
Customer ( 100) GEORGE FLOWERS, INC. 05/22/91
Different Phone Used 4072951704
Esc (Exit) F1 (Help) F2 (Edit) F3 (Incoming) F4 (Close) Alt N (Notes)
Alt M (Menu) Alt R (Reports) Alt O (Open) Alt B (PIN) Alt H (History)
Alt E (Customer) Alt Z (Supervisor) Alt F9 (Reindex) Alt f10 (Memory)
Select Incoming (New) Support Call
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 6
■ EXIT
Press Esc or select the first option of the main menu to exit DAYO SC
and return to DOS or a calling menu.
╔═══════════════╗
║╔═════════════╗║
║║╔═══════════╗║║
║║║ Exit (Y/N)║║║
║║╚═══════════╝║║
║╚═════════════╝║
╚═══════════════╝
■ EDIT CURRENT SUPPORT CALL RECORD
If you have already selected a support call record, you can edit it by
pressing F2. The record will be displayed onto the main menu screen, as
shown in the example on previous page.
A pop-up window appears for the two problem category prompts and for the
resolution prompt, ie:
╔══[ SELECT PROBLEM CATEGORY #1 ]══╗ ╔══[ SELECT PROBLEM CATEGORY #2 ]══╗
║ CATEGORY ║ ║ CATEGORY ║
║ ─────────────────────────────── ║ ║ ─────────────────────────────── ║
║ DAYO Inventory ║ ║ Configuration ║
║ DAYO Membership ║ ║ DOS 3.3 ║
║ DAYO Order Entry ║ ║ DOS 4.01 ║
║ DAYO POS ║ ║ DOS 5.0 ║
║ DAYO Passwords ║ ║ DOS 6.0 ║
║ DAYO Payroll ║ ║ DTP ║
║ DAYO Quotes ║ ║ Indexing ║
║ DAYO Rental POS ║ ║ Installation ║
║ DAYO Sales Management System ║ ║ Menu ║
║ DAYO Shipping Log ║ ║ Network - LANtastic ║
╚══════════════════════════════════╝ ╚══════════════════════════════════╝
╔══════[ SELECT RESOLUTION ]═══════╗
║ RESOLUTION ║
║ ─────────────────────────────── ║
║ ║
║ Could NOT fix! Gave up... ║
║ Fixed After very much research ║
║ Fixed Immediately ║
║ Not our problem ║
║ RECOMMEND TO GO BACK TO SCHOOL ║
║ Read DOS Manual ║
║ Read Network Manual ║
║ Reindex Fixed It ║
╚══════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 7
■ SELECT INCOMING PHONE CALL
If you are using a Voice Response Unit (VRU), you can have it integrated
with this program so that all new (incoming) support call records can
'automatically' be created when the PIN or customer calls into it.
When using a VRU, press F3 to select an incoming call. Note, only one
record will usually be present to select from.
╔═══════════════════════[ SELECT INCOMING PHONE CALL ]═══════════════════════╗
║PIN CATEGORY1 CATEGORY2 ║
║────────────╥────────────────────────────────╥──────────────────────────────║
║21091006008 ║ Hardware ║ Printer, Oki 193 ║
║21091006000 ║ Hardware ║ Printer, Laserjet ║
║21091006001 ║ Software ║ Ventura ║
║21091006003 ║ Hardware ║ Hand Scanner ║
║21091006004 ║ Hardware ║ Mouse ║
║21091006006 ║ Software ║ Windows ║
╚════════════════════════════════════════════════════════════════════════════╝
■ CLOSE CURRENT SUPPORT CALL
Press F4 to close the current support call record. When you close a
support call, a record of the call is made in the history database
(HISTORY.DBF), which includes notes.
A resolution code is required before a support call record can be closed.
╔════[ CLOSE CURRENT SUPPORT CALL! ]═════════════════════╗
║ You are about to CLOSE this support call! ║
║ ║
║ Resolution -> Fixed! ║
║ ║
║ Are you sure? (Y/N) ║
║ ║
╚════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 8
■ EDIT SUPPORT CALL/INCIDENT NOTES
Press Alt N while at the main menu, and after selecting an open support
call/incident, to edit the notes specific to that call/incident, ie:
╔══════════════════════════════════════════════════════╗┌───[October 1992]───┐
║ Name Elizabeth M Montgomery <OPEN> ║│S M T W T F S │
║ Reference 100013 ║├────────────────────┤
║ PIN 21091006000 CBAJB006000 ║│ 1 2 3 4 5│
║ Problem Software ║│ 6 7 8 9 10 11 12│
║ DTP ║│13 14 15 16 17 18 19│
║ Resolution ║│20 21 22 23 24 25 26│
║ Started 10/19/91 Time 12:01:01 ║┤27 28 29 30 31 │
║ Technician System Manager ║│ │
╚══════════════════════════════════════════════════════╝┴────────────────────┘
Type in anything you wish that pertains to the current support call incident.
Approximately 18 pages...
Esc (Exit) F1 (Help) F2 (Import)
1/0
■ RUN MENU
This routine was added to allow you to 'shell out' and run other programs
or applications while keeping DAYO SC in memory.
╔═════════════════════[ 'RUN ANOTHER APPLICATION' MENU ]═════════════════════╗
║FILENAME DESC LASTDATE LASTTIME RUNS ║
║────────────╥────────────────────────────────╥──────────╥──────────╥────────║
║BB.EXE ║ Blackbeard's Editor ║ 10/24/91 ║ 23:41:23 ║ 0 ║
║WP.COM ║ Word Perfect for windows ║ 10/20/91 ║ 10:25:07 ║ 0 ║
║COMMAND.COM ║ Exit To DOS ║ 10/20/91 ║ 15:13:35 ║ 541 ║
║DAYOINV.EXE ║ DAYO INVENTORY ║ 10/19/91 ║ 20:49:15 ║ 7 ║
║DAYOPOS.EXE ║ DAYO POS ║ 10/19/91 ║ 20:44:29 ║ 4 ║
║DAYOSMS.EXE ║ DAYO Sales Mgmt System ║ 10/19/91 ║ 23:56:56 ║ 4 ║
║PROCOMM.EXE ║ Procomm Plus Modem Program ║ 10/19/91 ║ 12:39:09 ║ 3 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Exit) Enter (Select) F2 (Edit) Ctrl N (Add)
Press Enter to select and run one of the applications. The DAYO SC
program memory will be placed into a temporary file and all but 11K memory
will be freed.
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 9
■ EDIT MENU RECORD
Press F2 to edit a menu record, ie:
╔════[ EDIT MENU RECORD ]════════════════════════════════╗
║ File Name NEW_PRG.EXE ║
║ Location C:\ ║
║ Description New program to list files ║
║ Number of Runs 0 ║
║ Last Date 10/20/91 ║
║ Last Time 10:25:07 ║
║ Date Added 10/20/91 ║
║ Last User System Manager ║
╚════════════════════════════════════════════════════════╝
■ ADD MENU RECORD
Press Ctrl N to add a new menu record. You will be presented with the
edit screen above, but you must enter a valid program/file name (they have
extensions of .EXE, .COM, and .BAT). Be sure to include a back slash '\'
after the location (as shown above...).
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 10
■ REPORTS
This menu option contains reports, labels and routines that enable you
to report your data. Most reports have multiple options that include indexes,
directing output to printer or file, and date ranges.
Use the arrow keys to select/highlight the desired report option, then
press Enter/Return.
DAYO SC Version 4.00 TJS LAB, Inc. ┌───[October 1992]───┐
Copyright (c) 1992 All Rights Reserved │S M T W T F S │
██▄███░ ▄███▄ ██░ ██░ ▄███▄ ▄████░ ▄████░ ├────────────────────┤
██░ ██░ ██░██░ ██░ ██░ ██░██░ ██░ ██░ │ 1 2 3 4 5│
██░ ██░ ██░██░ ▀████▀ ██░██░ ▀███▄ ██░ │ 6 7 8 9 10 11 12│
██░ ██░ ██▀▀▀██░ ██ ██░██░ ██░ ██░ │13 14 15 16 17 18 19│
██▀███░ ██░ ██░ ██░ ▀███▀ ████▀ ▀████░ │20 21 22 23 24 25 26│
┌───────────────────────────────────────────────────────┤27 28 29 30 31 │
│ User System Manager Time On 00:24:37 │ │
└───────────────────────────────────────────────────────┴─────┤00:25:15├─────┘
DAYO SUPPORT CALLS MANAGEMENT SYSTEM REPORTS
Select Report -> Printer Setup
PIN List
PIN Labels
PIN Phone List
█▄██░ ███░ █▄██░ ▄█▄ █▄██░ ████░ ▄██▄ PIN Expanded Report
█░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ PIN Usage/History Report
█▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ ▀██▄ Open Call Log List
█▀█░ █░ █░ █░█░ █▀█░ █░ █░ Daily Call Log Report
█░██░ ███░ █░ ▀█▀ █░██░ █░ ▀██▀ Incident/Support Call Log Report
Category #1/Problem List
Category #2/Problem List
Resolutions List
Esc (Exit) F1 (Help) Enter (Select)
■ REPORTS LISTING
Printer Setup Category #1/Problem List
PIN List Category #2/Problem List
PIN Labels Resolutions List
PIN Phone List Customer List
PIN Expanded Report Customer Labels
PIN Usage/History Report Configuration Status Report
Open Call Log List Calculator
Daily Call Log Report View Reports On Screen
Incident/Support Call Log Report
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 11
■ PRINTER SETUP/DRIVER
This routine was added to preclude you from having to get out of your
seat to change (mess with) the printer to get it to print correctly.
The most important printer selections (ie: font size, lines per inch,
orientation, ...) are made easy to evoke.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
║ ║
║ Select Option -> Eject ║
║ Line feed ║
║ Normal Size ║
║ Use this routine to set your Small/Condensed ║
║ printer up with one or more Bold On ║
║ of the setup strings and Bold Off ║
║ commands listed to the right. 6 Lines per Inch ║
║ 8 Lines per Inch ║
║ Select the 'Change Printer Print Landscape (Laser Only) ║
║ Default' option to change Print Portrait (Laser Only) ║
║ printer types. Reset Printer ║
║ Current printer is set to: Print Special String 1 ║
║ Okidata Print Special String 2 ║
║ Print Special String 3 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ PRINTER DRIVER OPTIONS
There are 18 printer driver options to select from. The last option is
to set the default printer, and the next to last is a 'SHELL' function that
runs a DOS command or program. The remainder are strings/codes that are sent
to the printer.
Eject Print Portrait (Laser Only)
Line feed Reset Printer
Normal Size Print Special String 1
Small/Condensed Print Special String 2
Bold On Print Special String 3
Bold Off Print Special String 4
6 Lines per Inch Print Special String 5
8 Lines per Inch Run DOS Command/Program
Print Landscape (Laser Only) Change Default Printer
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 12
■ CHANGE DEFAULT PRINTER
The last option is to change/set the default printer. This printer
driver routine comes with 4 default printer types, Epson, HP Laser, Star,
and Okidata.
You can add (Ctrl N) as many as you want.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Current Default Printer is set to: Okidata ║
╟────────────────────────────────────────────────────────────────────────────╢
║ NAME LINEFEED ║
║─────────────────────────────────────╥──────────────────────────────────────║
║ Epson & Compatibles ║ CHR(10) ║
║ HP Laser & Compatibles ║ CHR(10) ║
║ Star Micro Gemini ║ CHR(10) ║
║ Okidata ║ CHR(10) ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add)
1/4
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 13
■ FULL SCREEN EDIT - PRINTER DRIVER
When entering the printer codes, the string must be in the valid format
or it will not be printed later when requested...
┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐
│ NAME: Epson & Compatibles │
│ LINEFEED: CHR(10) │
│ NORMAL: CHR(27)+CHR(18) │
│ SMALL: CHR(27)+CHR(15) │
│ BOLDON: CHR(27)+CHR(69) │
│ BOLDOFF: CHR(27)+CHR(70) │
│ _6LPI: CHR(27)+CHR(50) │
│ _8LPI: CHR(27)+CHR(48) │
│ PORTRAIT: │
│ LANDSCAPE: │
│ RESET: CHR(27)+CHR(64) │
│ SPEC_STR1: │
│ SPEC_STR2: │
│ SPEC_STR3: │
│ SPEC_STR4: │
│ SPEC_STR5: │
│ RUN_CMD: │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ PRINTER DRIVER DATABASE FIELD DEFINITIONS
NAME - Name of printer. Type in anything you wish here
LINEFEED - Code to advance printer one line
NORMAL - Normal font/character size
SMALL - Small font/character size
BOLDON - Bold/Emphasized
BOLDOFF - Bold/Emphasized off
_6LPI - Code to set printer to print 6 lines per inch
_8LPI - Code to set printer to print 8 lines per inch
PORTRAIT - Code to set laser printer to print upright (normal)
LANDSCAPE - Code to set laser printer to print sideways
RESET - Reset printer code
SPEC_STR1 - Any special printer string, ie: print double, skip perforation,
SPEC_STR2 - print very tiny, ...
SPEC_STR3 - "
SPEC_STR4 - "
SPEC_STR5 - "
RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ...
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 14
■ PIN LIST
The PIN LIST consists of key fields of the Personal Identification
Number (PIN) database (PIN.DBF). This report is 132 characters wide, so
be sure to set your printer to print small if you do not have a wide
carriage printer.
The 1st prompt is for the index. Note, the first two options (PIN and
Customer Number), already have indexes, but the remaining ones will have to
be created...
╔════════════════════════════════[ PIN LIST ]════════════════════════════════╗
║ This is a Simple PIN Listing indexed by one of seven indexes, ie: ║
║ PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║
║ Resolution. Note, only the first two indexes require an index. ║
║ This Report is 132 characters wide. Uses Report Form: PINLIST.FRM. ║
║ ║
║ ║
║ Select Index -> PIN ║
║ Customer Number ║
║ Name (Lastname, Firstname) ║
║ Initiating Date ║
║ Ending Date ║
║ Last Problem ║
║ Last Resolution ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 15
The next prompt is for the range or scope. This is where you defined
what records will print, ie: All, specific customer number, or for a selected
date range.
╔════════════════════════════════[ PIN LIST ]════════════════════════════════╗
║ This is a Simple PIN Listing indexed by one of seven indexes, ie: ║
║ PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║
║ Resolution. Note, only the first two indexes require an index. ║
║ This Report is 132 characters wide. Uses Report Form: PINLIST.FRM. ║
║ ║
║ ║
║ Select Index -> PIN ║
║ ║
║ Select Option -> All Undeleted Records ║
║ Specific PIN Type (Left 5 characters) ║
║ Specific Customer Number ║
║ Starting Date Range ║
║ Ending Date Range ║
║ Last Problem ║
║ Last Resolution ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 16
If a specific field is selected, you will be prompted to enter the
desired string to search for.
You have the option of directing the output of the report to printer or
file.
╔════════════════════════════════[ PIN LIST ]════════════════════════════════╗
║ This is a Simple PIN Listing indexed by one of seven indexes, ie: ║
║ PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║
║ Resolution. Note, only the first two indexes require an index. ║
║ This Report is 132 characters wide. Uses Report Form: PINLIST.FRM. ║
║ ║
║ ║
║ Select Index -> PIN ║
║ ║
║ Select Option -> Specific PIN Type (Left 5 characters) ║
║ ║
║ Enter PIN type: 21091 ║
║ ║
║ ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: PINLIST.TXT ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 17
If you decided to direct the output to a printer, you will be presented
with the option to 'setup' that printer, ie:
╔═══════════════════════════════════╗
║ Select Printer Option(s) ║
║ Printer: Epson & Compatibles ║
║ Eject ║
║ Line feed ║
║ Normal Size ║
║ Small/Condensed ║
║ Bold On ║
║ Bold Off ║
║ 6 Lines per Inch ║
║ 8 Lines per Inch ║
║ Print Landscape (Laser Only) ║
║ Print Portrait (Laser Only) ║
║ Reset Printer ║
║ Print Special String 1 ║
║ Print Special String 2 ║
║ Print Special String 3 ║
║ Print Special String 4 ║
║ Print Special String 5 ║
║ Press Esc to Exit ║
╚═══════════════════════════════════╝
Esc (Exit) F1 (Help)
Use the PRINTER SETUP/DRIVER routine to defined/set the default printer.
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 18
■ PIN LABELS
This option lets you print address labels for your PIN records. The
output is directed to the printer only.
╔═══════════════════════════════════════════════════════╗
║Use this option to print the PIN address labels. ║
║The Address Label is the standard size of: ║
║ 3.5x15/16, 6LPI, and contains the following fields: ║
║ FNAME + LNAME ADDRESS1 ADDRESS2 ║
║ CITY STATE ZIP ║
║ ║
║ ╒══════════════════════════════╕ ║
║ │GEORGE Sams │ ║
║ │13 WEST COLONIAL │ ║
║ │ │ ║
║ │ORLANDO, FL │ ║
║ │32802 │ ║
║ ╘══════════════════════════════╛ ║
║ PIN CUSTOMER FNAME ║
║Select PIN -> 11091000018 100 ║
║ 11091000019 100 ║
║ 11091000020 100 ║
║ 11091000021 100 GEORGE ║
║ 11091000022 100 ║
║Esc (Exit) Enter (Print) F3(ALL) F5/F6/F7/F8(Find) ║
╚═══════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 19
■ PIN PHONE LIST
This is a report consisting of the PIN number and phone numbers.
Options include multiple indexes, scope/range, and the option to print
to printer or file.
╔═════════════════════════════[ PIN PHONE LIST ]═════════════════════════════╗
║ This is a Simple PIN Telephone Listing indexed by one of seven indexes, ║
║ ie: PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║
║ Last Resolution. Note, only the first two indexes require an index. ║
║ This Report is 80 characters wide. Uses Report Form: PINPHONE.FRM. ║
║ ║
║ ║
║ Select Index -> PIN ║
║ Customer Number ║
║ Name (Lastname, Firstname) ║
║ Initiating Date ║
║ Ending Date ║
║ Last Problem ║
║ Last Resolution ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 20
■ EXPANDED PIN REPORT
This is a report consisting of the key PIN fields.
Options include multiple indexes, scope/range, and the option to print
to printer or file.
╔══════════════════════════[ EXPANDED PIN REPORT ]═══════════════════════════╗
║ This is the Expanded PIN Report indexed by one of seven indexes, ie: ║
║ PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║
║ Resolution. Note, only the first two indexes require an index. ║
║ This Report is 155 characters wide. Uses Report Form: PINRPT.FRM. ║
║ ║
║ ║
║ Select Index -> PIN ║
║ ║
║ Select Option -> All Undeleted Records ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ Enter File Name: PINRPT.TXT ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 21
■ PIN USAGE & HISTORY REPORT
This is a report consisting of the key incident/support call records of
only closed incident records. Use this report to track usage.
Options include scope/range and the option to print to printer or file.
╔═══════════════════════[ PIN USAGE & HISTORY REPORT ]═══════════════════════╗
║ This is a report of all incidents/support calls for each PIN. ║
║ The Report is only indexed by the PIN value. ║
║ This Report is 132 characters wide. Uses Report Form: USAGE.FRM. ║
║ ║
║ ║
║ Select Option -> All Undeleted Records ║
║ Specific PIN or PIN Type ║
║ Specific Customer Number ║
║ Starting Date Range ║
║ Ending Date Range ║
║ Problem ║
║ Resolution ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 22
■ OPEN INCOMING PHONE LOG LISTING
This is a simple listing of only the open incoming phone log records.
Gets it's data from the database LOG.DBF.
╔════════════════════[ OPEN INCOMING PHONE LOG LISTING ]═════════════════════╗
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: LOGLIST.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
■ OPEN SUPPORT CALLS REPORT
This is a report consisting of key fields of the open incidents/support
call records. The report is wider than usual, so be sure to set your printer
to print very small (even if you have a wide carriage printer).
Options include multiple indexes, scope/range, and the option to print
to printer or file.
╔═══════════════════════[ OPEN SUPPORT CALLS REPORT ]════════════════════════╗
║ This is a report of all open & active incidents/support calls. ║
║ The Report is indexed by one of seven indexes. ║
║ This Report is 155 characters wide. Uses Report Form: OPEN.FRM. ║
║ ║
║ Select Index -> Reference Number ║
║ PIN ║
║ Customer Number ║
║ Initiating Date + Time ║
║ Problem ║
║ Technician ║
║ Comments ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 23
■ CALL LOG (HISTORY) REPORT
This report is almost identical to the Usage report, except that this
one also includes the notes. Note, it only prints records with notes...
The report is wider than usual, so be sure to set your printer to print
very small (even if you have a wide carriage printer).
Options include multiple indexes, scope/range, and the option to print
to printer or file.
╔═══════════════════════[ CALL LOG (HISTORY) REPORT ]════════════════════════╗
║ This is an complete report of all incidents/support calls for each PIN. ║
║ The Report is only indexed by the PIN value. It is very similar to the ║
║ USAGE report, but includes the incident notes. ║
║ This Report is 155 characters wide. Uses Report Form: CALL_LOG.FRM. ║
║ ║
║ Select Option -> All Undeleted Records ║
║ Specific PIN or PIN Type ║
║ Specific Customer Number ║
║ Starting Date Range ║
║ Ending Date Range ║
║ Problem ║
║ Resolution ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
■ CATEGORY #1 PROBLEM LISTING
Use this option to print a listing of the category 1 problem codes to
the printer or a file.
╔══════════════════════[ CATEGORY #1 PROBLEM LISTING ]═══════════════════════╗
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: CAT1LIST.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 24
■ CATEGORY #2 PROBLEM LISTING
Use this option to print a listing of the category 2 problem codes to
the printer or a file.
╔══════════════════════[ CATEGORY #2 PROBLEM LISTING ]═══════════════════════╗
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: CAT2LIST.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
■ RESOLUTION LISTING
Use this option to print a listing of the resolution codes to the
printer or a file.
╔═══════════════════════════[ RESOLUTION LISTING ]═══════════════════════════╗
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: RESOLIST.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
■ CATEGORY #1 PROBLEM LISTING
Use this option to print a listing of all your customer records to the
printer or a file.
╔════════════════════════════[ CUSTOMER LISTING ]════════════════════════════╗
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: CUSTLIST.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 25
■ CUSTOMER BILL TO ADDRESS LABELS
Use this option to print labels containing the customer's address, to a
printer only.
╔═══════════════════════════════════════════════════════╗
║Use this option to print the Customer Bill To address ║
║Labels. The Address Label is the standard size of ║
║ 3.5x15/16, 6LPI, and contains the following fields: ║
║ NAME ADDR1 ADDR2 ║
║ CITY STATE ZIP ║
║ ║
║ ╒══════════════════════════════╕ ║
║ │GEORGE MOONILAL │ ║
║ │13 WEST COLONIAL │ ║
║ │ │ ║
║ │ORLANDO, FL │ ║
║ │32802 │ ║
║ ╘══════════════════════════════╛ ║
║ CUSTOMER ║
║Select Customer -> 120 ║
║ 122 ║
║ 123 ║
║ 124 ║
║ 135 ║
║Esc (Exit) Enter (Print) F3(ALL) F5/F6/F7/F8(Find) ║
╚═══════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 26
■ CONFIGURATION STATUS REPORT
This is a simple listing of your configuration settings. Note, you should
keep this 'on file' should the configuration file get erased/lost...
╔═══════════════════════════════════════════════════════╗
║The Configuration Status Settings Report lists all of ║
║configuration settings (found in file DAYOSC.CFG). ║
║This is Not a Report Form. ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: CONFIG.TXT ║
╚═══════════════════════════════════════════════════════╝
■ EXAMPLE OF A CONFIGURATION STATUS REPORT
+++++++++++++++++++++++++++++++++++++++++++
+ DAYO SUPPORT CALLS CONFIGURATION REPORT +
+++++++++++++++++++++++++++++++++++++++++++
10/28/91
23:07:20
Company Name: YOUR COMPANY, INC
Address Line 1: Attn: Accounts Receivable
Address Line 2: P.O. BOX 5555
City, State Zip: Anycity, ST 555555-5555
Telephone: 800-555-5555
Last Customer Number: 0
Allow Adding of Customer: Yes
Customer Database Location: \DAYOAR\
Phone Log Database Location:
Current Directory:
Use Passwords: Yes
Note Screen Size: 50
Screen Font #: 1
Default Excluded Menu Options: QC
Report Printer Port: LPT1
Automatically Reindex Daily: Yes
Color: Yes
High Intensity: Yes
Serial Number Conversion Codes
Replace 0 with A
Replace 1 with B
Replace 2 with C
Replace 3 with D
Replace 4 with E
Replace 5 with F
Replace 6 with G
Replace 7 with H
Replace 8 with O
Replace 9 with J
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 27
■ CALCULATOR
This routine emulates a calculator. Use the numeric key pad or number
keys.
╔═════[ CALCULATOR ]═════╗
║┌──────────────────────┐║
║│ 101.000000 +│║
║│ 50 │║
║└──────────────────────┘║
║ ┌─┐ ┌─┐ ┌─┐ ┌─┐ ┌─┐║
║ │7│ │8│ │9│ │*│ │S│║
║ └─┘ └─┘ └─┘ └─┘ └─┘║
║ ┌─┐ ┌─┐ ┌─┐ ┌─┐ ┌─┐║
║ │4│ │5│ │6│ │/│ │R│║
║ └─┘ └─┘ └─┘ └─┘ └─┘║
║ ┌─┐ ┌─┐ ┌─┐ ┌─┐ ┌─┐║
║ │1│ │2│ │3│ │+│ │C│║
║ └─┘ └─┘ └─┘ └─┘ └─┘║
║ ┌─┐ TJS ┌─┐ ┌─┐ ┌─┐║
║ │0│ LAB │.│ │-│ │E│║
║ └─┘ INC └─┘ └─┘ └─┘║
╚════════════════════════╝
■ VIEW REPORTS ON SCREEN
This routine was provided to aid the 'fight to stop the cutting down of
trees in the world' by offering you the option to view your reports on your
screen. The only limitation is on the size of the report. No reports can be
viewed if they are over 32,000 bytes. (Just kidding about those trees...)
Due to compiler problems (handling of memory), this routine tends to
'hang' your computer. It is not recommended you use this option if your
machine is performing multitasking programs.
At the first prompt, type and enter the name of the report you wish to
view.
╔═════════════════════════▌ View Reports Onscreen ▐══════════════════════════╗
║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ██████║
║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║
║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║
║ ████░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║
║ ██░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║
║ ║
║ Use this option to view (and optionally print) any report written to disk. ║
║ Press Enter/Return on an empty prompt to display all files with the ║
║ extension of '.TXT'. ║
║ No limit on file size, but a large file/report takes longer to 'load'... ║
║ ║
║ Enter Report File Name to View On Screen: ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 28
If the file does not exist, or you press enter on an empty prompt, a
window will appear showing all reports in the current directory. It is
assumed that all reports will have the extension of '.TXT', which is the
DAYO standard.
All reports are displayed in the window, even if they are too large...
╔═══════════════════════════════════════╗
║ File Name Size Date Used ║
╟──────────────┬────────────┬───────────╢
║DAYOERR.TXT │ 1090 │ 06/15/90 ║
║BALANCE.TXT │ 3555 │ 06/15/90 ║
║GL900615.TXT │ 79 │ 06/15/90 ║
║CONFIG.TXT │ 1209 │ 06/15/90 ║
║BUDGETSC.TXT │ 4129 │ 06/15/90 ║
║CLASSRPT.TXT │ 1058 │ 06/02/90 ║
║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐
║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │
║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │
║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │
║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │
║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘
║TRANS1.TXT │ 659 │ 06/15/90 ║
║ASSETS.TXT │ 1300 │ 06/15/90 ║
║EQUITY.TXT │ 714 │ 06/15/90 ║
╚══════════════╧════════════╧═══════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 29
■ REPORT VIEWING SCREEN
The report viewing screen uses the complete screen. The top line
displays the report name. The bottom lines show you the function keys,
all 2 of them. Also displayed at the bottom of the screen is the current
row/column of the cursor position.
DAYORPT View Reports │ File Name: COA.TXT
Page No. 1
07/27/90
INVENTORY ITEM LISTING
Vendor or
Item Mfg Item Description
------------ ------------ ------------------------------
2"GUTTER 2" GUTTER SYSTEM _____________
2ALM518 2" ALMOND COIL _____________
2ALM519 2" ALMOND COIL _____________
2ALM527 2" ALMOND COIL _____________
2ALM533 2" ALMOND COIL _____________
2ANT123 2" ANT IVORY COIL _____________
Esc (Exit) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 30
■ BROWSE OPEN SUPPORT CALLS/RECORDS
This is the routine you will use to store open support calls/incident
records. From this routine you can edit the record or the notes for the
currently highlighted record, or add a new record.
* If you do not have a VRU, you will be using this routine to add all
your new open support call records.
╔════[ OPEN SUPPORT CALLS ]════════════════════════════╗┌───[October 1992]───┐
║ Name George Montgomery <OPEN> ║│S M T W T F S │
║ Reference 100014 ║├────────────────────┤
║ PIN 21091006003 ║│ 1 2 3 4 5│
║ Problem First time use/installation of Ventura ║│ 6 7 8 9 10 11 12│
║ DTP ║│13 14 15 16 17 18 19│
║ Resolution ║│20 21 22 23 24 25 26│
║ Started 10/19/91 Time 12:01:01 ║┤27 28 29 30 31 │
║ Technician System Manager ║│ │
╚══════════════════════════════════════════════════════╝┴─────┤23:17:26├─────┘
REFERENCE PIN CUSTOMER CATEGORY1
───────────────╥─────────────╥──────────╥─────────────────────────────────────
100004 ║ 21091006005 ║ 100 ║ Hardware
100005 ║ 21091006006 ║ 100 ║ Hardware
100006 ║ 21091006004 ║ 100 ║ Hardware
100007 ║ 21091006001 ║ 100 ║ Software
100010 ║ 21091006006 ║ 100 ║ Hardware
100012 ║ 21091006002 ║ 100 ║ DAYO Inventory
100013 ║ 21091006000 ║ 100 ║ Hardware
100014 ║ 21091006003 ║ 100 ║ Software/Ventura
100015 ║ 21091006004 ║ 100 ║ Hardware
Esc (Exit) F1 (Help) Enter (Select) F2 (Edit) Alt N (Note)
Ctrl N (Add) Ctrl U (Delete)
Find: F5 (Reference) F6 (PIN) F7 (Open + PIN)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 31
■ FULL SCREEN EDIT - OPEN SUPPORT CALL RECORD
Press F2 to edit all the fields of the currently highlighted open support
call records.
┌────────────[ FULL SCREEN EDIT - SUPPORT CALL/INCIDENT RECORD ]─────────────┐
│ REFERENCE: 100004 │
│ PIN: 21091006005 │
│ CUSTOMER: 100 │
│ CATEGORY1: Hardware │
│ CATEGORY2: Printer │
│ RESOLUTION: │
│ COMMENTS: │
│ PHONE: 4072924708 │
│ DATE: 10/19/91 │
│ TIME: 12:01:01 │
│ ENDDATE: / / │
│ ENDTIME: │
│ TECHNICIAN: SYSTEM MANAGER │
│ CLOSEDBY: │
│ OPEN: T │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 32
■ EDIT SUPPORT CALL/INCIDENT NOTES
Press Alt N to edit the notes (up to 18 pages), for the currently
highlighted record.
The screen size can be 25, 43 or 50 lines. The screen size is set in the
configuration menu.
╔══════════════════════════════════════════════════════╗┌───[October 1992]───┐
║ Name Brenda Montgomery ║│S M T W T F S │
║ Reference 100004 ║├────────────────────┤
║ PIN 21091006005 CBAJB006005 ║│ 1 2 3 4 5│
║ Problem Software ║│ 6 7 8 9 10 11 12│
║ DTP ║│13 14 15 16 17 18 19│
║ Resolution ║│20 21 22 23 24 25 26│
║ Started 10/19/91 Time 12:01:01 ║┤27 28 29 30 31 │
║ Technician SYSTEM MANAGER ║│ │
╚══════════════════════════════════════════════════════╝┴────────────────────┘
Write in anything you wish into this space that pertains to the current
support call/incident.
Esc (Exit) F1 (Help) F2 (Import)
1/0
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 33
■ ADD SUPPORT CALL/INCIDENT RECORD
Press Ctrl N to add/create a new support call/incident record.
The first prompt will be for a valid/existing customer, then you will
be prompted to edit the new/empty record.
┌──────────[ FULL SCREEN EDIT - ADD SUPPORT CALL/INCIDENT RECORD ]───────────┐
│ PIN CUSTOMER FNAME LNAME │
│ Select ─────────────────╥──────────╥─────────────────╥────────────────────│
│ PIN -> 11091000039 ║ 100 ║ Lorraine ║ Turner │
│ 11091000040 ║ 100 ║ Michael ║ Smith │
│ 11091000041 ║ 100 ║ Darrell ║ Kelly │
│ 11091000042 ║ 100 ║ Paul Lenard ║ Johnson │
│ 11091000043 ║ 100 ║ Mark ║ Johnson │
│ 11091000044 ║ 100 ║ GEORGE ║ Moonilal │
│ 21091006000 ║ 100 ║ Elizabeth M ║ Montgomery │
│ 21091006001 ║ 100 ║ Joe ║ Montgomery │
│ 21091006002 ║ 100 ║ Sally ║ Montgomery │
│ 21091006003 ║ 100 ║ George ║ Montgomery │
│ 21091006004 ║ 100 ║ Ronald ║ Montgomery │
│ 21091006005 ║ 100 ║ Brenda ║ Montgomery │
│ 21091006006 ║ 100 ║ Paul ║ Montgomery │
│ 21091006007 ║ 100 ║ Paul ║ Montgomery │
│ 21091006008 ║ 100 ║ Paul ║ Montgomery │
└────────────────────────────────────────────────────────────────────────────┘
Esc (Exit) F1 (Help) Enter (Select) Find: F5/F6/F7/F8 Alt F (FastFind)
11/119
■ FIND PIN RECORD WHILE CREATING A NEW SUPPORT CALL RECORD
There are four (4) indexes for the PIN database (PIN.DBF).
Press F5 to find a PIN record based on the PIN number, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter PIN: │
└───────────────────────────────────────────────────TJS LAB───┘
Press F6 to find a PIN record based on the customer
number, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter CUSTOMER: 0 │
└───────────────────────────────────────────────────TJS LAB───┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 34
Press F7 to find a PIN record based on the first name,
ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter FNAME: │
└───────────────────────────────────────────────────TJS LAB───┘
Press F8 to find a PIN record based on the last name, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter LNAME: │
└───────────────────────────────────────────────────TJS LAB───┘
■ FAST FIND PIN WHILE CREATING A NEW SUPPORT CALL RECORD
This special search routine lets you locate PIN records with only
parts (strings) of the PIN last name, first name, phone 1 and/or zip code,
ie:
╔════════════════════════════════════════════════════════════════════════════╗
║ PIN FAST FIND ║
║ PIN Last Name First Name Phone 1 Zip ║
║ 21091006003 Montgomery George 4072924708 32810-0001║
║ 12323006004 Jones George (407) 555-4204 32831 ║
║ 43555506006 Moonilal George (407) 555-4234 32736 ║
║ 11091006021 Smith George (407) 555-2048 32825 ║
║ 11091000044 Tallahassee George (407) 555-9348 32832 ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Enter String(s): GEORGE ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter (Select) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 35
■ FIND INCIDENT/SUPPORT CALL RECORD
The open support call database (OPEN.DBF), is indexed by three (3)
indexes, but only the first 2 are useful. The 3rd index simply puts the
open record before the closed ones (OPEN=.T.).
Press F5 to locate an open support call record based on the reference
number, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter REFERENCE: 0 │
└───────────────────────────────────────────────────TJS LAB───┘
Press F6 to locate an open support call record based on the PIN, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter PIN: │
└───────────────────────────────────────────────────TJS LAB───┘
Press F7 to locate an open support call record based on the status
(whether it is open or not). This search routine is useful only if you want
to go to the top of the file and see the oldest, but still OPEN support
call/incident record.
┌─────────────────────────────────────────────────────────────┐
│ Enter IIF(OPEN,CHR(48),CHR(49))+STR(REFERENCE): │
└───────────────────────────────────────────────────TJS LAB───┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 36
■ BROWSE PIN DATABASE
This is the maintenance routine for the PIN records. From this routine,
you can edit the record, add new records and edit the PIN notes.
╔════[ PIN DATABASE BROWSE ]═══════════════════════════╗┌───[October 1992]───┐
║ Name GEORGE Calls 0 ║│S M T W T F S │
║ Started 11091000044 BBAJB000044 ║├────────────────────┤
║ PIN 10/20/91 / / ║│ 1 2 3 4 5│
║ Last Problem ║│ 6 7 8 9 10 11 12│
║ ║│13 14 15 16 17 18 19│
║ Last Resolution ║│20 21 22 23 24 25 26│
║ City/State/Zip ORLANDO, FL 32802 ║┤27 28 29 30 31 │
║ Phones (407) 292-4708 (407) 295-2171 ║│ │
╚══════════════════════════════════════════════════════╝┴─────┤23:31:55├─────┘
PIN CUSTOMER FNAME LNAME
──────────────────────╥──────────╥─────────────────╥──────────────────────────
11091000044 ║ 100 ║ GEORGE ║
21091006000 ║ 100 ║ Elizabeth M ║ Montgomery
21091006001 ║ 100 ║ Joe ║ Montgomery
21091006002 ║ 100 ║ Sally ║ Montgomery
21091006003 ║ 100 ║ George ║ Montgomery
21091006004 ║ 100 ║ Ronald ║ Montgomery
21091006005 ║ 100 ║ Brenda ║ Montgomery
21091006006 ║ 100 ║ Paul ║ Montgomery
23423423423 ║ 43423 ║ 2342 ║ 3423
Esc (Exit) F1 (Help) F2 (Edit) Alt N (PIN Notes)
Ctrl N (Add)
Find: F5 (PIN) F6 (Customer) F7 (FName) F8 (LName) Alt F (FastFind)
119/119
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 37
■ FULL SCREEN EDIT - PIN RECORD
Press F2 to edit an open support call record.
┌─────────────[ FULL SCREEN EDIT - SUPPORT CALL/INCIDENT RECORD ]────────────┐
│ PIN: 11091000044 LASTTIME: 22:25:45 │
│ CUSTOMER: 100 │
│ FNAME: GEORGE │
│ LNAME: │
│ ADDRESS1: 13 WEST COLONIAL │
│ ADDRESS2: │
│ CITY: ORLANDO │
│ STATE: FL │
│ ZIP: 32802 │
│ PHONE1: (407) 292-4708 │
│ PHONE2: (407) 295-2171 │
│ DOB: / / │
│ SSN: │
│ DATE: 10/20/91 │
│ TIME: 22:25:45 │
│ ENDDATE: / / │
│ CALLS: 0 │
│ LASTCAT1: │
│ LASTCAT2: │
│ LASTRESOLU: │
│ LASTDATE: 10/20/91 │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ FIND PIN RECORD
There are four (4) indexes for the PIN database (PIN.DBF).
Press F5 to find a PIN record based on the PIN number, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter PIN: │
└───────────────────────────────────────────────────TJS LAB───┘
Press F6 to find a PIN record based on the CUSTOMER number, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter CUSTOMER: 0 │
└───────────────────────────────────────────────────TJS LAB───┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 38
Press F7 to find a PIN record based on the first name, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter FNAME: │
└───────────────────────────────────────────────────TJS LAB───┘
Press F8 to find a PIN record based on the last name, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter LNAME: │
└───────────────────────────────────────────────────TJS LAB───┘
■ FAST FIND PIN
This special search routine lets you locate PIN records with only
parts (strings) of the PIN last name, first name, phone 1 and/or zip code,
ie:
╔════════════════════════════════════════════════════════════════════════════╗
║ PIN FAST FIND ║
║ PIN Last Name First Name Phone 1 Zip ║
║ 21091006003 Montgomery George 4072924708 32810-0001║
║ 12323006004 Jones George (407) 555-4204 32831 ║
║ 43555506006 Moonilal George (407) 555-4234 32736 ║
║ 11091006021 Smith George (407) 555-2048 32825 ║
║ 11091000044 Tallahassee George (407) 555-9348 32832 ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Enter String(s): GEORGE ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter (Select) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 39
■ EDIT PIN NOTES
Press Alt N to edit the notes (up to 18 pages), for the currently
highlighted record.
The screen size can be 25, 43 or 50 lines. The screen size is set in the
configuration menu.
╔══════════════════════════════════════════════════════╗┌───[October 1992]───┐
║ Name George Montgomery ║│S M T W T F S │
║ PIN 21091006003 CBAJB006003 ║├────────────────────┤
║ Last Date 10/25/91 ║│ 1 2 3 4 5│
║ ██▄███░ ████░ ██░ ██░ ║│ 6 7 8 9 10 11 12│
║ ██░ ██░ ██░ ███▄ ██░ ║│13 14 15 16 17 18 19│
║ ██████░ ██░ ███████░ NOTES ║│20 21 22 23 24 25 26│
║ ██░ ██░ ██░▀███░ ║┤27 28 29 30 31 │
║ ██░ ████░ ██░ ██░ ║│ │
╚══════════════════════════════════════════════════════╝┴────────────────────┘
Type in anything you want that pertains specifically to the selected/current
PIN/Customer...
Esc (Exit) F1 (Help) F2 (Import)
1/0
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 40
■ BROWSE HISTORY OF SUPPORT CALLS DATABASE
This is the maintenance routine for the history of support calls records.
From this routine, you can edit the record, add new records and edit the
support call/incident notes.
The records in this database are created when you close an open
support call/record. Data is 'moved' from the OPEN database to the HISTORY
database.
╔════[ HISTORY OF SUPPORT CALLS ]══════════════════════╗┌───[October 1992]───┐
║ Name George Montgomery ║│S M T W T F S │
║ Reference 100071 ║├────────────────────┤
║ PIN 21091006003 ║│ 1 2 3 4 5│
║ Problem Hardware ║│ 6 7 8 9 10 11 12│
║ Printer ║│13 14 15 16 17 18 19│
║ Resolution ║│20 21 22 23 24 25 26│
║ Started 10/25/91 Ended 10/25/91 Days 0 ║┤27 28 29 30 31 │
║ Technician System Manager ║│ │
╚══════════════════════════════════════════════════════╝┴─────┤23:33:23├─────┘
REFERENCE PIN CUSTOMER CATEGORY1
───────────────╥─────────────╥──────────╥────────────────────────────────────
100071 ║ 21091006003 ║ 100 ║ Hardware
100003 ║ 21091006003 ║ 100 ║ Hardware
100014 ║ 21091006003 ║ 100 ║ Hardware
100018 ║ 21091006003 ║ 100 ║ Hardware
100031 ║ 21091006003 ║ 100 ║ Hardware
100039 ║ 21091006003 ║ 100 ║ Hardware
100048 ║ 21091006003 ║ 100 ║ Hardware
100060 ║ 21091006003 ║ 100 ║ Hardware
100003 ║ 21091006003 ║ 100 ║ Hardware
Esc (Exit) F1 (Help) F2 (Edit) Alt N (Notes)
Find: F5 (Reference) F6 (PIN)
17/74
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 41
■ FULL SCREEN EDIT - HISTORY SUPPORT CALL/INCIDENT RECORD
Press F2 to edit the currently highlighted support call history record.
┌─────────────[ FULL SCREEN EDIT - SUPPORT CALL/INCIDENT RECORD ]────────────┐
│ REFERENCE: 100071 │
│ PIN: 21091006003 │
│ CUSTOMER: 100 │
│ CATEGORY1: Hardware │
│ CATEGORY2: Printer │
│ RESOLUTION: Dip Switches │
│ COMMENTS: │
│ PHONE: 4072924708 │
│ DATE: 10/25/91 │
│ TIME: 12:01:01 │
│ ENDDATE: 10/25/91 │
│ ENDTIME: 00:15:18 │
│ TECHNICIAN: System Manager │
│ CLOSEDBY: System Manager │
│ OPEN: F │
│ │
│ │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 42
■ EDIT HISTORY SUPPORT CALL/INCIDENT NOTES
Press Alt N to edit the notes pertaining to the currently highlighted
record.
The screen size can be 25, 43 or 50 lines. The screen size is set in the
configuration menu.
╔══════════════════════════════════════════════════════╗┌───[October 1992]───┐
║ Name George Montgomery ║│S M T W T F S │
║ Reference 100071 ║├────────────────────┤
║ PIN 21091006003 CBAJB006003 ║│ 1 2 3 4 5│
║ Problem Software ║│ 6 7 8 9 10 11 12│
║ DTP ║│13 14 15 16 17 18 19│
║ Resolution ║│20 21 22 23 24 25 26│
║ Started 10/25/91 Ended 10/25/91 Days 0 ║┤27 28 29 30 31 │
║ Technician System Manager ║│ │
╚══════════════════════════════════════════════════════╝┴────────────────────┘
Notes pertaining to the incident go in the full screen editor/notes
section
Esc (Exit) F1 (Help) F2 (Import)
1/0
■ FIND HISTORY SUPPORT CALL/INCIDENT RECORD
The HISTORY database (HISTORY.DBF) is indexed by two (2) indexes.
Press F5 to find a history record based on the reference number. Note,
the reference number must be 'padded' with leading spaces in order for the
seek function to work.
┌─────────────────────────────────────────────────────────────┐
│ Enter DESCEND(STR(REFERENCE)+DTOS(ENDDATE)): │
└───────────────────────────────────────────────────TJS LAB───┘
Press F6 to find a history record based on the PIN (or a portion of it),
ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter DESCEND(PIN+DTOS(ENDDATE)): │
└───────────────────────────────────────────────────TJS LAB───┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 43
■ BROWSE CUSTOMERS
This is the routine that lets you view and optionally add, customer
records. Note, no editing of the record is permitted, but you can add
a customer record. It is recommended that the customer record be edited from
the DAYO AR module. The record can be edited in the MISC Routines, but this
often corrupts the index...
╔════════════════════════════════════════════════════════════════════════════╗
║ BILL TO: SHIP TO: ║
║ GEORGE MOONILAL ║
║ 13 WEST COLONIAL ║
║ ║
║ ORLANDO, FL 32802 ║
║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║
║ 100 REG LT CASH PICKUP ║
║ PHONE ATTN LASTDATE ║
║ (407) 292-4708 RICH LAROSSA 104091.64 10/01/91 ║
╚══════════════════════[ BROWSE THE CUSTOMER DATABASE ]══════════════════════╝
CUSTOMER NAME ATTN
───────────╥────────────────────────────────╥─────────────────────────────────
100 ║ GEORGE MOONILAL ║ RICH LAROSSA
101 ║ HARRY MORGAN ║ HARRY
102 ║ AL'S SPECIAL CHEESEBURGERS ║ AL
117 ║ ENERGYVISION ║ GINO
164 ║ HARPER FLOWERS ║ SANDRA
188 ║ DAVE NICKERSON ENT. ║
292 ║ JOHNSON'S MOBILE HOME REPAIR ║
294 ║ ABLE GLASS ║ OSCAR
Esc (Exit) F1 (Help) Ctrl N (Add) Ctrl U (Delete/Recall)
Find: F5(Customer) F6(Name) F7(ShipTo) F8(Phone) F9(Zip)
128/146
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 44
■ ADD A NEW RECORD - FULL SCREEN EDIT
Press Ctrl N to add a new customer record. Note, the option to be able
to do this can be 'turned off' in the configuration menu.
┌──────────────────[ ADD A NEW RECORD - FULL SCREEN EDIT ]───────────────────┐
│ CUSTOMER: 10331 LASTDATE: / / │
│ NAME: TYPE: REG │
│ ATTN: CLASS: AR │
│ ADDR1: PBM: 0.000 │
│ ADDR2: PBL: 0.000 │
│ CITY: SALESPTD: 0.00 │
│ STATE: SALESYTD: 0.00 │
│ ZIP: DUE: 0.00 │
│ SHIPNAME: PAID_PURC: 0.00 │
│ SHIPADDR1: LIMIT: 0.00 │
│ SHIPADDR2: ACTIVE: T │
│ SHIPCITY: TAXCODE: │
│ SHIPSTATE: FAX: │
│ SHIPZIP: SHIPPHONE: │
│ PHONE: FOB: │
│ SALESPER: PRICEX: 0 │
│ RATE: 0.000 CREDCARD: │
│ TAXRATE: 0.0000 TAXRATE2: 0.00000 │
│ TERMS: CUSCODE: │
│ SHIPPER: │
│ DATE: 10/29/91 │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ FIND CUSTOMER RECORD
There are 5 indexes for the customer database.
Press F5 to find a customer record based on the customer number, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter CUSTOMER: 0 │
└───────────────────────────────────────────────────TJS LAB───┘
Press F6 to find a customer record based on the name, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter NAME: │
└───────────────────────────────────────────────────TJS 43
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 45
Press F7 to find a customer record based on the customer ship to name,
ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter SHIPNAME: │
└───────────────────────────────────────────────────TJS LAB───┘
Press F8 to find a customer record based on the right 4 digits of the
telephone number, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter right 4 digits Phone: │
└───────────────────────────────────────────────────TJS LAB───┘
Press F10 to find a customer record based on the zip code, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter ZIP: │
└───────────────────────────────────────────────────TJS LAB───┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 46
■ SUPERVISOR OPTIONS (CONFIGURATION)
This is the menu of all the configuration options and special routines.
The key fields are the company name, address and database locations.
╔════════════════════════╗
║ SUPERVISOR OPTIONS ║
╟────────────────────────╢
║ Company Name ║
║ Company Address ║
║ Company Telephone ║
║ Last Reference # ║
║ Allow Customer Add ║
║ Customer Location ║
║ Phone Log Location ║
║ Current Directory ║
║ Browse Category #1 ║
║ Browse Category #2 ║
║ Browse Resolutions ║
║ Serial Number Codes ║
║ Notes Screen Size ║
║ Assign PIN Blocks ║
║ Browse Phone Log ║
║ Excluded Options ║
║ Use Passwords ║
║ Passwords ║
╟────────────────────────╢
║ Select Option ║
╚════════════════════════╝
■ CONFIGURATION LISTING
Company Name Browse Phone Log
Company Address Excluded Options
Company Telephone Use Passwords
Last Reference # Passwords
Allow Customer Add Global Pack & Reindex
Customer Location Misc Routines
Phone Log Location Screen Fonts
Current Directory System Statistics
Browse Category #1 Report Printer Port
Browse Category #2 Auto Daily Indexing
Browse Resolutions Color
Serial Number Codes High Intensity
Notes Screen Size Credits
Assign PIN Blocks
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 47
■ COMPANY NAME
This is the name of your company or organization.
╔══════════════════════════════[ COMPANY NAME ]══════════════════════════════╗
║ Enter Your Company Name: YOUR COMPANY, INC ║
╚════════════════════════════════════════════════════════════════════════════╝
■ COMPANY ADDRESS
This is the address of your company or organization.
╔════════════════════════════[ COMPANY ADDRESS ]═════════════════════════════╗
║ Address Line 1: Attn: Accounts Receivable ║
║ Address Line 2: P.O. BOX 5555 ║
║ City, State ZIP: Anycity, ST 555555-5555 ║
╚════════════════════════════════════════════════════════════════════════════╝
■ COMPANY TELEPHONE
This is the telephone number of your company or organization.
╔═══════════════════════════[ COMPANY TELEPHONE ]════════════════════════════╗
║ Enter Your Company Telephone: 800-555-5555 ║
╚════════════════════════════════════════════════════════════════════════════╝
■ LAST REFERENCE NUMBER
This option lets you determine what the next support call/incident
number (REFERENCE) will be. Note, keep the number much less than 999,999,
since this is the maximum, and will cause errors if the number exceeds this!
╔═════════════════════════[ LAST REFERENCE NUMBER ]══════════════════════════╗
║ Note, this option should be maintained by the System Manager! ║
║ ║
║ Enter Last Reference Number: 100075 ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 48
■ ALLOW CUSTOMER ADD
This option determines if customer records can be added to the customer
database while viewing/browsing the customer database. The default is to
allow it, but in many environments, it is not recommended, especially where
DAYO accounting modules are being used...
╔═══════════════════════════[ ALLOW CUSTOMER ADD ]═══════════════════════════╗
║ If you want the ability to add customer records while in the Customer ║
║ Browse routine, then select Y (Yes) to this option. Note, it is not ║
║ recommended to add customer records from DAYO SC if you have DAYO AR ║
║ or DAYO POS installed! Default is to allow customer add. ║
║ ║
║ Do you want to add customer records? (Y/N) ║
╚════════════════════════════════════════════════════════════════════════════╝
■ CUSTOMER DATABASE LOCATION/DIRECTORY
This is the location of the customer database (CUSTOMER.DBF). The default
is to use the one found in the DAYO AR directory (if installed). If no other
DAYO module is installed, you will be using the one in the current directory,
so leave the field blank.
╔══════════════════[ CUSTOMER DATABASE LOCATION/DIRECTORY ]══════════════════╗
║ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be ║
║ in the same drive/directory as DAYO SC. If you have installed the DAYO ║
║ Customer Database (CUSTOMER.DBF), into a different directory, you need ║
║ to tell DAYO SC where to find it. Default is nil (current directory). ║
║ Be sure to include the rightmost slash, ie: \DAYOAR\ ║
║ The drive designation is optional (if same as DAYO SC). ║
║ ║
║ Enter Location: \DAYOAR\ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 49
■ 'RAW' PHONE LOG DATABASE LOCATION/DIRECTORY
This is the location of the Voice Response Unit (VRU) Files. It can not
be the same directory as DAYO SC or can it 'share' it with any other files.
All files in this directory will be ERASED when used in the INCOMING option.
If you do not have a VRU, then ignore this option.
╔══════════════[ 'RAW' PHONE LOG DATABASE LOCATION/DIRECTORY ]═══════════════╗
║ The location of the Telephone Log Files that are generated by the ║
║ Voice Response Unit (VRU), should be a directory of its own. It can not ║
║ be the same directory as DAYO SC! ║
║ Default is current directory + '\LOG', ie: \DAYOSC\LOG\ ║
║ Be sure to include the rightmost back slash... ║
║ ║
║ ║
║ Enter Location: ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
■ CURRENT DIRECTORY DATABASE LOCATION
Use this option to defined the location of the DAYOSC databases if not
in the current directory.
╔══════════════════[ CURRENT DIRECTORY DATABASE LOCATION ]═══════════════════╗
║ This module's databases can be located in a different location other ║
║ than the current directory. If you have and wish to use ALL the ║
║ databases currently found in this directory from a different drive and ║
║ directory, then you need to tell this module where to find them. ║
║ Be sure to include the rightmost slash, ie: C:\DAYOSC\ ║
║ The drive designation is optional if same as this module. ║
║ ║
║ Enter Location: ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 50
■ BROWSE PROBLEM CATEGORY #1
This is the maintenance routine for the editing and adding of category
#1 problem codes, ie:
╔══[ BROWSE PROBLEM CATEGORY #1 ]══╗
║ CATEGORY ║
║ ─────────────────────────────── ║
║ BRAIN ║
║ DAYO AP ║
║ DAYO AR ║
║ DAYO End of Period ║
║ DAYO GL ║
║ DAYO Index ║
║ DAYO Inventory ║
║ DAYO Membership ║
║ DAYO Order Entry ║
║ DAYO POS ║
║ DAYO Passwords ║
║ DAYO Payroll ║
║ ║
║ ║
║ ║
║ ║
╚══════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete)
■ FULL SCREEN EDIT - CATEGORY 2 RECORD
Press F2 to edit a category #1 record, which consists of only the problem
code.
┌─────────────────────[ FULL SCREEN EDIT - EDIT RECORD ]─────────────────────┐
│ CATEGORY: Configuration │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 51
■ BROWSE PROBLEM CATEGORY #2
This is the maintenance routine for the editing and adding of category
#2 problem codes, ie:
╔══[ BROWSE PROBLEM CATEGORY #2 ]══╗
║ CATEGORY ║
║ ─────────────────────────────── ║
║ Configuration ║
║ DOS 3.3 ║
║ DOS 4.01 ║
║ DOS 5.0 ║
║ DOS 6.0 ║
║ DTP ║
║ Indexing ║
║ Installation ║
║ Menu ║
║ Network - LANtastic ║
║ Network - Novell ║
║ Network - Other ║
║ ║
║ ║
║ ║
║ ║
╚══════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete)
■ FULL SCREEN EDIT - CATEGORY 2 RECORD
Press F2 to edit a category #2 record, which consists of only the problem
code.
┌─────────────────────[ FULL SCREEN EDIT - EDIT RECORD ]─────────────────────┐
│ CATEGORY: Pagemaker │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 52
■ BROWSE RESOLUTION DATABASE
This is the maintenance routine for the editing and adding of resolution
codes, ie:
╔══[ BROWSE RESOLUTION DATABASE ]══╗
║ RESOLUTION ║
║ ─────────────────────────────── ║
║ ║
║ Could NOT fix! Gave up... ║
║ Fixed After very much research ║
║ Fixed Immediately ║
║ Not our problem ║
║ RECOMMEND TO GO BACK TO SCHOOL ║
║ Read DOS Manual ║
║ Read Network Manual ║
║ Reindex Fixed It ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚══════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete)
2/9
■ FULL SCREEN EDIT - RESOLUTION RECORD
Press F2 to edit a resolution record, which consists of only the code.
┌─────────────────────[ FULL SCREEN EDIT - EDIT RECORD ]─────────────────────┐
│ RESOLUTION: Could NOT fix! │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 53
■ EDIT SERIAL NUMBER CODES
Serial number are actually the PIN numbers, just coded/encrypted. This
option lets you determine how you want the first 5 digits of the PIN
encrypted. PINs are composed on numeric digits only, but this process will
generate and display a serial number (to be issued to users or placed on
or in manuals).
Using the settings below, the following PIN will be coded as shown.
PIN -> 31091006000
|||||
SERIAL NUMBER -> DBAJB006000
╔════════════════════════[ EDIT SERIAL NUMBER CODES ]════════════════════════╗
║ Serial Numbers are Codes PIN numbers. For each numeric digit of the ║
║ PIN number, you have the option of assigning a replacement character. ║
║ Use Serial Numbers to assign to individual support packages... ║
║ Note, leave the prompt blank if you do not want a change or conversion. ║
║ ║
║ Convert '0' to: A ║
║ Convert '1' to: B ║
║ Convert '2' to: C ║
║ Convert '3' to: D ║
║ Convert '4' to: E ║
║ Convert '5' to: F ║
║ Convert '6' to: G ║
║ Convert '7' to: H ║
║ Convert '8' to: O ║
║ Convert '9' to: J ║
╚════════════════════════════════════════════════════════════════════════════╝
■ EDIT NOTES - SCREEN MODE: 25, 43 (EGA), or 50 (VGA) LINES
If you have an EGA or VGA screen, you can edit the notes (PIN or Support
Call/Incident), using 25, 43, or 50 lines. EGA can use 25 or 43, VGA can
use all three options.
╔═══════[ EDIT NOTES - SCREEN MODE: 25, 43 (EGA), or 50 (VGA) lines ]════════╗
║ If you have an EGA or VGA card, you have the option to display more ║
║ than the usual 25 lines per screen while editing any Notes. ║
║ The default is 43 lines if EGA or VGA is installed, else 25... ║
║ ║
║ Select Option -> Normal: 25 lines ║
║ EGA: 43 lines ║
║ VGA: 50 lines ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 54
■ ASSIGN PIN BLOCKS/NUMBERS
Use this routine to add/create new PIN records if you sell multiple
packages (PINs) to a customer. Use the Ctrl N (Add) function in the PIN
Database Browse routine to add the PIN records if only one PIN record is
created for each customer.
Each PIN is made up of a type code, month, year and a number value.
You are prompted to enter each of these values, but the system will increment
the number as it creates the records. The example screen below shows how 10
PIN records will be created for customer number '100':
╔═══════════════════════[ ASSIGN PIN BLOCKS/NUMBERS ]════════════════════════╗
║ Format (11 digits), ie: 30191006000 ║
║ Type Month Year Number ║
║ 9 99 99 999999 ║
║ ║
║ Enter Customer Number: 100 Enter Type: 1 ║
║ Name SHERRY JOHNSON Month: 11 ║
║ Address #5 GEORGETOWN Year: 91 ║
║ 962 GEORGETOWN Starting Number: 10 ║
║ NORTH AUGUSTA, SC 29841 Ending Number: 10 ║
║ 803 278-4304 Maximum Calls: 0 ║
║ Number of Days: 0 ║
║ ║
║ Valid TYPEs: '0' through '9' ║
║ Set the Maximum Calls to Zero (0) if no limit on number of calls. ║
║ Set the Number of Days to Zero (0) if no limit on number of days. ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 55
The progress of the PIN adding is displayed/scrolled upon the screen, ie:
╔═══════════════════════[ ASSIGN PIN BLOCKS/NUMBERS ]════════════════════════╗
║ Format (11 digits), ie: 30191006000 ║
║ Type Month Year Number ║
║ 9 99 99 999999 ║
║ ║
║ Enter Customer Number: 100 Enter Type: 1 ║
║ Name GEORGE MOONILAL Month: 10 ║
║ Address 13 WEST COLONIAL Year: 91 ║
║ 13 WEST COLONIAL Starting Number: 11 ║
║ ORLANDO, FL 32802 Ending Number: 20 ║
║ (407) 292-4708 ║
║ ║
║ ║
║ Standby! Adding new/blank PIN records (no names) ║
║ 1 10 91 001009 11091000017 7 of 10 ║
║ 1 10 91 001008 11091000016 6 of 10 ║
║ 1 10 91 001007 11091000015 5 of 10 ║
║ 1 10 91 001006 11091000014 4 of 10 ║
║ 1 10 91 001005 11091000013 3 of 10 ║
║ 1 10 91 001004 11091000012 2 of 10 ║
║ 1 10 91 001003 11091000011 1 of 10 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
■ BROWSE 'RAW' PHONE LOG DATABASE
This is the maintenance routine for the VRU generated telephone log.
╔════════════════════[ BROWSE 'RAW' PHONE LOG DATABASE ]═════════════════════╗
║ PIN CATEGORY1 ║
║────────────────────────────╥───────────────────────────────────────────────║
║ 21091006001 ║ Software ║
║ 21091006003 ║ Software ║
║ 21091006005 ║ Hardware ║
║ 21091006007 ║ Hardware ║
║ 21091006008 ║ Hardware ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete)
<DELETED> 1/51
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 56
■ FULL SCREEN EDIT - VRU/LOG.DBF RECORD
Press F2 to edit the VRU log/database record. Note, the number of fields
will vary depending on the manufacturer of the VRU...
┌─────────────────────[ FULL SCREEN EDIT - EDIT RECORD ]─────────────────────┐
│ PIN: 21091006001 │
│ CATEGORY1: Software │
│ CATEGORY2: DTP │
│ PHONE: 4072924708 │
│ DATE: 10/15/91 │
│ TIME: 12:01:01 │
│ CLOSED: T │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 57
■ DEFAULT EXCLUDED MAIN MENU OPTIONS (USED WITH PASSWORDS)
If you activate the passwords routine, you can exclude your users from
the main menu options by assigning them excluded option codes listed below.
This option prompts you to enter the excluded codes that you want all new
users/passwords to have (they can be overridden).
Excluded Main Menu Excluded Main Menu
Code Option Code Option
──── ───────────── ──── ─────────────────────
Q Esc (Exit) R Alt R (Reports)
H F1 (Help) O Alt O (Open)
2 F2 (Edit) B Alt B (PIN)
3 F3 (Incoming) P Alt H (History Browse)
4 F4 (Close) C Ctrl C (Customer)
N Alt N (Notes) Z Alt F1 (Supervisor)
M Alt M (Menu) X Alt F9 (Reindex)
╔════════[ DEFAULT EXCLUDED MAIN MENU OPTIONS (USED WITH PASSWORDS) ]════════╗
║ The default excluded menu options in this prompt will become the ║
║ default for each new user/technician added in the Password Routine. ║
║ ║
║ Enter the Default Excluded Main Menu Options: QC ║
╚════════════════════════════════════════════════════════════════════════════╝
■ USE PASSWORDS
This option turns off/on the use of passwords. Note, the default for the
use of passwords is NOT to activate them.
╔═════════════════════════════[ USE PASSWORDS ]══════════════════════════════╗
║ Use this option to activate/deactivate the requirement for passwords. ║
║ The default is to deactivate the passwords... ║
║ ║
║ Use Passwords? (Y/N) ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 58
■ PASSWORDS MAINTENANCE
If you use passwords, this is the routine that you will use to add and
edit them. Note, the password is stored in an encrypted format, but is
displayed (decrypted) onto the center screen.
*** Password information is contained in the file: 'CALLOG.CFG'.
╔═════════════════════════[ PASSWORDS MAINTENANCE ]══════════════════════════╗
║ Excluded Main Menu Excluded Main Menu ║
║ Code Option Code Option ║
║ Q Esc (Exit) R Alt R (Reports) ║
║ H F1 (Help) O Alt O (Open) ║
║ 2 F2 (Edit) B Alt B (PIN) ║
║ 3 F3 (Incoming) P Alt H (History Browse) ║
║ 4 F4 (Close) C Ctrl C (Customer) ║
║ N Alt N (Notes) Z Alt F1 (Supervisor) ║
║ M Alt M (Menu) X Alt F9 (Reindex) ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Name SYSTEM MANAGER Password TJ Active Yes ║
║ Login SUPERVISOR Status Logged Out Date 10/15/91 ║
║ Exclude Options Started 10/28/91 Time 23:17:12 ║
╟────────────────────────────────────────────────────────────────────────────╢
║ PASSWORD LOGIN NAME ║
║──────────╥────────────────────────────────╥────────────────────────────────║
║ SH ║ SUPERVISOR ║ SYSTEM MANAGER ║
║ SH ║ TOM ║ Thomas Lyle Johnson ║
║ d?eK ║ BOSS ║ John Michael Gonzales ║
║ ahyK ║ REG_001 ║ REGISTER #1 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete)
■ EDIT/ADD PASSWORD
Press F2 to edit a password record, or Ctrl N to add a new one. The
edit screen for either is in the center of the screen.
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 59
■ NOVELL NETWORK & PASSWORDS
If you are running Novell's Netware (tm), you can configure the network
to make it possible for DAYO SC to automatically read the username, validate
it, and then enter the program without even stopping to ask for a password.
If installed onto a Novell (tm) network, the SUPERVISOR must make or
insure that the 'MACHINE NAME' statement is found in the LOGIN SCRIPT. The
LOGIN SCRIPT can be edited from within the SYSCON program. The use of the
MACHINE NAME statement is not necessary if passwords are not used.
┌────────────────────────────────────────────────────────────────────────────┐
│NetWare System Configuration V2.20d Saturday May 11, 1992 6:32 pm│
│ User SUPERVISOR On File Server ORLANDO │
└────────────────────────────────────────────────────────────────────────────┘
╔════════════════════════════════════════════════════════════════════════════╗
║ System Login Script ║
╠════════════════════════════════════════════════════════════════════════════╣
║MAP G:=VOL1:\ ║
║MAP INS S1:=SYS:\PUBLIC ║
║MAP INS S1:=ORLANDO/SYS:\WORD5 ║
║MAP INS S1:=ORLANDO/SYS:\UTILITY ║
║MAP INS S1:=ORLANDO/SYS:\ATC\EXE ║
║MAP INS S1:=ORLANDO/SYS:\ATC\NS ║
║MAP INS S1:=ORLANDO/SYS:\MHS\EXE ║
║DOS SET MV="ORLANDO/SYS:" ║
║ ║
║MACHINE NAME=LOGIN_NAME ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Call us for any help on this matter if you have a Novell network running.
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 60
■ GLOBAL PACK & REINDEX
This option simply indexes all databases. Requires exclusive use
of all databases accessed by DAYO SC.
╔════════════════[ GLOBAL PACK & REINDEX ]══════════════════╗
║ This routine REQUIRES EXCLUSIVE USE of the databases! ║
║ That means that everyone must be out of the databases ║
║ if on a network... ║
║ This is the routine that PACKS all DAYO SC databases, ║
║ removing any records marked for deletion! Note, this ║
║ routine should be performed at least monthly... ║
║ ║
║ ║
║ Are You Sure? (Y/N) ║
╚═══════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 61
■ MISCELLANEOUS ROUTINES
The MISC routines is a collection of 17 very useful Database Management
Routines. These routines provide you with the 'ability to do whatever was
left out of the rest of the program...'. These routines were modeled after
dBase (tm) III+/IV functions. Familiarity with dBase will help with the
understanding and execution of these routines.
This routine option is found inside the Supervisor's menu (Alt Z from
main menu).
USE WITH CAUTION!
YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES
YOU CAN ALSO MESS THINGS UP PERMANENTLY!
■ MISC ROUTINES MENU:
DAYO SC Version 2.01 TJS LAB, Inc. ┌───[November 1992]──┐
╔════════════════════╗═══╗ghts Reserved │S M T W T F S │
║ MISC ROUTINES ║ ║███▄ ▄████░ ▄████░ ├────────────────────┤
╟────────────────────╢╔═════════════════════════════════════════════════════╗│
║ APPEND FROM ║║ This menu option provides you with a multitude of ║│
║ BROWSE DATABASES ║║ database management tools and functions, but also ║│
║ COPY (.DBF) TO ║║ can be a source of significant problems! ║│
║ CREATE DATABASE ║║ ║│
║ DELETE RECORDS ║║ Miscellaneous Routines was provided to give you a ║│
║ ERASE FILE ║║ 'back door' to DAYO, but if used incorrectly, it ║┘
║ EXIT TO DOS ║║ can damage or destroy your data! ║
║ INDEX A DATABASE ║║ ║
║ LIST FIELDS ║║ Adding records to databases, packing, appending, ║
║ PACK DATABASE ║║ editing records and modify databases can ║
║ MODIFY DATABASE ║║ corrupt the indexes related to the database(s)! ║
║ RECALL RECORDS ║║ You must know to reindex (Alt F9) if you do any ║
║ RETURN TO MENU ║║ of these operations... ║
║ RUN (DOS COMMAND) ║║ ║
║ SIMPLE EDITOR ║║ When modifying a database, the rule is to NEVER ║
║ SORT DATABASE ║║ change an existing field; only to add new fields...║
║ TYPE (PRINT) FILE ║║ ║
║ ZAP DATABASE ║║ Remember that 'ZAP' means to remove (permanently) ║
╟────────────────────╢║ all records in the selected database! ║
║ Select Option ║╚═════════════════════════════════════════════════════╝
╚════════════════════╝═══╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 62
■ APPEND FROM
Used to copy records from one database into another database, or to
create records from ASCII files (SDF or DELIMITED).
The Initial Screen will prompt you to enter the file name of the database
you are to append/copy the data into. At this point, you can either type in
the name of the target database, or ...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
└────────────────────────────────────────────────────────────────────────────┘
If it exists in the current directory, press enter on an empty prompt to
display all databases to select from.
┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │INVENT.DBF │ 375 │ 09/16/89 │ │
│ │AR.DBF │ 7219 │ 09/16/89 │ │
│ │HISTORY.DBF │ 103 │ 09/16/89 │ │
│ │PERSONS.DBF │ 24271 │ 09/16/89 │ │
│ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
│ │
└───────────────────────────────────────────────────────────────────────────┘
The next prompt will be to select the type of Append:
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
└──────────────────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 63
If you are appending from another database (.DBF) then select 'Standard'.
Select the SDF option if you are appending from a 'flat' ASCII file.
Select the DELIMITED option if you are appending from a delimited ASCII
file. Delimited files contain records in which the fields are separated by
commas, and its character fields contained in double quotes...
If you select a Standard Append, you will then be prompted to enter the
name of the database you wish to get the data from. If you selected the SDF
or DELIMITED options, then enter the file name containing the data to be
appended into your target database.
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into PERSONS.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: PERSON1.TXT │
│ │
│ │
└──────────────────────────────────────────────────────────────────────────┘
The number of records appended into the target database will be displayed
upon completion of the task...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF From INVENTY.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: INVENTY.DBF │
│ │
│ │
│ │
│ There Were 1 Records Appended Into INVENT.DBF │
│ │
│ │
│ │
│ Press Any Key To Continue... │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 64
■ BROWSE DATABASES
Used to edit/view records in a database. Enter the database name you wish
to edit/browse, or if it exists in the current directory, press enter on an
empty prompt to bring up a window box to select from.
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: INVENT.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
If there exists an index (.NDX or .NTX), with the same name as the
database, it will be utilized... The DAYO Inventory indexes are the
exception. They are automatically set/used.
An example of a browse screen:
TJS LAB, PO BOX 585366
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ MFG_PART DESC PRICE LIST │
│──────────────────╥────────────────────────────────╥────────────╥───────────│
│ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │
│ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │
│ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │
│ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │
│ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │
│ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │
│ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │
│ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │
│ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │
│ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │
│ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │
│ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │
│ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │
│ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │
│ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │
│ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │
│ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │
├──────────────────╨────────────────────────────────╨────────────╨───────────┤
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
51/60
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 65
To edit a memo field, just highlight the field, and start typing.
* * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING!
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ PRICE LIST YOURPART NOTES │
│───────────────────────╥────────────╥─────────────────╥─────────────────────│
│ 896.16 ║ 1792.32 ║ ║ <Memo> │
│ 1064.19 ║ 2128.38 ║ ║ <Memo> │
│ 672.12 ║ 1344.24 ║ ║ <Memo> │
│ 1736.31 ║ 3472.62 ║ ║ <Memo> │
│ 504.09 ║ 1008.18 ║ ║ <Memo> │
│ 784.14 ║ 1568.28 ║ ║ <Memo> │
│ 1400.25 ║ 2800.50 ║ ║ <Memo> │
┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐
│You can edit memo fields too... │
│ │
│ │
│ │
│ │
│ │
│ │
└───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
Special keys for 'moving around' the BROWSE screen are:
Left Arrow Key - Move to next field to your left
Right Arrow Key - Move to next field to your right
Ctrl Home - Go to the leftmost field
Ctrl End - Go to the rightmost field (on the end of the record)
Up Arrow - Move highlight to the previous record
Down Arrow - Move highlight to the next record
PgUp - Page up a full screen of records
PgDn - Page down a full screen of records
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end or last record of the file
Ctrl N - Add a record (where applicable)
Ctrl U - Delete a record (where applicable)
F5 - To seek/find a record based upon the active index
Esc - Exit the current operation
Remember that there are many more fields to the right of the screen.
Press the right arrow key to view them...
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 66
■ COPY (.DBF) TO
Copy records to another (new) database. Use this option to copy select
records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can
also be used to create backups of data (IE: copy to floppy).
┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │HARPS.DBF │ 375 │ 09/16/89 │ │
│ │INVENT.DBF │ 7335 │ 09/16/89 │ │
│ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │
│ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │
│ │AP.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
The next prompt will be to select the type of COPY TO option you want:
┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: INVENT.DBF │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ │
│ Copy Records From INVENT.DBF │
└────────────────────────────────────────────────────────────────────────────┘
The Standard option is simply creating another database (.DBF). The SDF
and DELIMITED options will create ASCII files. The STRUCTURE option creates a
new database with the same file structure as the initial database (no
records copied).
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 67
The next prompt (optional), requires some knowledge of dBase (tm). This
prompt is requesting the user to enter a condition or filter. If all
records are to be copied, just press Enter on an empty prompt.
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW.DBF │
│ │
│ Enter Condition: │
│ Sample condition: COST > 100 │
│ │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
This 'Condition' option is useful for coping only specific records into a
new location. Any valid dBase/Clipper statement (as shown next) is
fine...
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW DBF │
│ │
│ Enter Condition: PRICE>0 │
│ Sample condition: COST > 100 │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 68
The following window message will appear while the COPY TO routine does
its task:
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW10 │
│ │
│ Enter Condition: PRICE>0 │
│ Sample cond┌───────────────────────────────────────────────┐ │
│ │┌─────────────────────────────────────────────┐│ │
│ CONDITION: ││┌───────────────────────────────────────────┐││ │
│ │││┌─────────────────────────────────────────┐│││ │
│ ││││Hold those camels while I do this COPY TO││││ │
│ │││└─────────────────────────────────────────┘│││ │
│ ││└───────────────────────────────────────────┘││ │
│ │└─────────────────────────────────────────────┘│ │
│ └───────────────────────────────────────────────┘ │
│ Copy Records From SDF To NEW10 │
└────────────────────────────────────────────────────────────────────────────┘
■ CREATE DATABASE
Create a new database. This routine lets you create entirely new database
structures. At the FIELD_NAME field, enter a unique field name. At the
FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date,
'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the
size/length of the character and/or numeric field. At the FIELD_DEC field,
enter the number of decimals for the numeric field.
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ ║ ║ 0 ║ 0 │
│ ║ ║ ║ │
│ ║ ║ ║ │
┌─────────────│ ║ ║ ║ │────────────┐
│ │ ║ ║ ║ │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 69
* * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * *
IT IS SLIGHTLY BOTHERSOME
SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING...
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to edit the new database.
This error may even cause your computer to hang!
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ NAME ║ C ║ 30 ║ 0 │
│ AGE ║ N ║ 5 ║ 1 │
│ DEAD ║ L ║ 1 ║ 0 │
│ BIRTHDATE ║ D ║ 8 ║ 0 │
┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐
│ │ ║ ║ 0 ║ 0 │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│ ║ ║ ║ │
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 70
■ DELETE RECORDS
Delete selected records from databases. The first prompt is for the name
of the database you wish to mark records for deletion. Like many of the other
routines, you can press enter on an empty prompt to bring up all databases
that exist in the current directory:
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│D.DBF │ 259 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/16/89 │
│XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└────────────────────────────────────────────────────────────────────────────┘
After selecting the database, all its fields will be presented atop the
screen so as to aid the user in entering a condition/filter. The use of the
condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax
is required. Note the use of the Clipper Function: EMPTY().
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐
│ Enter Database Name: TRASH │
│ Delete Records For Condition: EMPTY(PART) │
│ Sample condition: COST > 100 │
│ CONDITION: EMPTY(PART) │
│ Number of Records Deleted: 208 │
│ Press any key to continue... │
└────────────────────────────────────────────────────────────────────────────┘
The number of records deleted will be displayed upon the screen as
depicted just above...
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 71
■ ERASE FILE
Erase a file (forever!). Use this option with extreme care!
Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY
REMOVED FROM EXISTENCE
NO SECOND CHANCES HERE...
The first prompt is for the file name. You can press enter on an empty
prompt to bring up a window selection of all files in the current directory.
┌────────────────────────┐
┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘
│BKDOOR.DOC │ 37029 │ 09/17/89 │
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│D.DBF │ 259 │ 09/16/89 │
│D.DBT │ 512 │ 09/16/89 │
│DAYOBK.BAK │ 36879 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
│DAYOBK.OBJ │ 35585 │ 09/16/89 │
│DAYOCAL.MAP │ 35 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│DDD.DBT │ 512 │ 09/16/89 │
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
* To ERASE a file, just highlight it, then press Enter...
■ EXIT TO DOS
This option will close all open files and databases and exit to DOS
without having to return to the main menu exit routine.
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 72
■ INDEX A DATABASE
You will be prompted to select the database you wish to index. After
selecting the database, by typing in the name or pressing Enter on an empty
prompt (then selecting from the window), you will be given a listing of all
fields in that database atop the screen.
┌────────[ PICK A DATABASE ]───────────┐.
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DAD.DBF │ 259 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SPW.DBF │ 7335 │ 09/16/89 │
│SOW.DBF │ 103 │ 09/16/89 │
│BOY.DBF │ 24387 │ 09/17/89 │
│SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
You will now be prompted to enter the name of the Index File. It will be
(by default), named exactly the same as the selected database, with the
exception of the extension. This will default to .NDX or .NTX depending on
whether you linked NDX.OBJ with your application.
*** Remember that the BROWSE routine only looks at indexes with the same
name as the database.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
└───────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 73
At the prompt for the index key, enter a field name, or a valid
dBase/Clipper expression.
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
│ Enter the Key Expression: PART+MFG_PART │
└───────────────────────────────────────────────────────────────┘
■ LIST FIELDS
List fields to screen or printer. This routine is a great tool for
providing simple reports and lists. The first prompt will be for the database
you wish to work with. Type the name of the file, or press Enter on an empty
prompt to bring up a window of all databases in the current directory for
selection.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│INVEND.DBF │ 259 │ 09/16/89 │
│INVENT.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SOMEDAY.DBF │ 7335 │ 09/16/89 │
│TANGO.DBF │ 103 │ 09/16/89 │
│AP.DBF │ 24387 │ 09/17/89 │
│BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 74
The next prompt is for a condition or filter. This makes it possible to
list only specific records that meet that condition you enter. The condition
must be a valid dBase/Clipper expression, or none (to list all).
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌─────────────────────────────────────────────────────┐
│ Enter Filter: │
│ IE: ID = "SAM0909" .AND. RETAIL > 10000 │
└─────────────────────────────────────────────────────┘
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: │
│ │
└───────────────────────────────────────────────────────────────┘
A window box appears next displaying all the fields in the selected
database and an option to list all fields. Highlight any combination of
fields ( or ALL) that you want listed.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║ ├─────────────────┤ ║
╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝
│RECNO() │
│MFG_PART │
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 75
The fields you select will be displayed at center top of screen. Press
Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│DESC┌──────────────────────────────────────────────────────────────────┐
│PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │
│LIST│ │
│YOUR└──────────────────────────────────────────────────────────────────┘─┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 76
The list is very simple, and if displayed onto the screen, may look like
the following:
PART MFG_PART PRICE
4523 0.00
DAYO9S 41926 1904.34
DAYO10S 13564 616.11
DAYOCOMP 45625 2072.37
DAYOALLS 43159 1960.35
INDEXER 50558 2296.41
INDEXERS 51791 2352.42
5 DEMO 4932 224.04
DAYO13S 20963 952.17
MENUS 53024 2408.43
OFFSITEP 56724 2576.46
ONSITEP 57957 2632.47
DAYO2S 24662 1120.20
DAYO9 40693 1848.33
DAYO10 12331 560.10
DAYOCAL$ 44392 2016.36
DAYO13 19730 896.16
DAYO2 23429 1064.19
DAYO11 14797 672.12
DAYO8 38227 1736.31
DAYO1 11098 504.09
DAYO12 17264 784.14
DAYO5 30828 1400.25
......PRESS ANY KEY TO CONTINUE......
■ MODIFY DATABASE
Change the fields/structure of a database. You can add new fields, delete
fields, change the length and type of field in any of the databases. At the
FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter
a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M'
for memofield. At the FIELD_LEN field, enter the size/length of the
character and/or numeric field. At the FIELD_DEC field, enter the number of
decimals for the numeric field.
********************************************************
*** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST ***
*** IT IS SLIGHTLY BOTHERSOME SORRY! ***
********************************************************
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to access the database.
This error may even cause your computer to hang!
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 77
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
■ PACK DATABASE
Pack a database (removed deleted records). This option will permanently
remove any records marked for deletion. This is another routine you should
use with great care! As in many of the other of the routines, you will be
prompted to enter the name of the database you wish to pack. Enter the name
or press Enter on an empty prompt to view the window.
┌─────┐
│PACK!│
└─────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│GOODDATA.DBF │ 259 │ 09/16/89 │
│HAP.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│LOIN.DBF │ 103 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/17/89 │
│FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
After selecting the database, you will be prompted to respond with a Yes
or No (to Pack or not to Pack...). This is the last chance you have to change
your mind...
┌──────────────────────────────────────────────────────────────────────────┐
│ PACK TOM3 │
│ Are you sure you want to PACK (remove deleted records) ? N │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 78
■ RECALL RECORDS
Recalls records previously marked for deletion. This option is identical
to the DELETE RECORDS option discussed earlier...
■ RETURN TO MENU
Returns to the procedure that called MISC Routines.
■ RUN (DOS COMMAND)
Run a DOS command (EG: dir/w). This option is helpful in that it allows
you to run programs at the DOS level (within memory constraints).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN CD\DOS │
└───────────────────────────────────────────────────────────────────────────┘
One useful option is to type and Enter: COMMAND at this prompt. You will
be running another DOS Shell totally out of the program (it still is in
memory though).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN COMMAND │
└───────────────────────────────────────────────────────────────────────────┘
Press and Enter: EXIT to return to your Clipper Application.
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 79
■ SIMPLE EDITOR
A simple editor and word processor. Use this option to create and read
simple TEXT files. File size is limited to your machines capabilities or
32,000k. The first prompt is for the name of the file you wish to edit. Type
in the name, or press Enter on an empty prompt to bring up a window option
box containing all files in the current directory.
┌────────────────────────┐
┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐
│ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │
│ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │
└────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
│DEMO.MAP │ 7780 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
*** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...),
so be careful at what you select for viewing/editing.
If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE
those changes. If you exit with an Esc, all changes will be lost!
┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐
│CLIPPER demo │
│CLIPPER MISC │
│KWAIT 10 │
│LIB MISC-+MISC,MISC.LST,MISC │
│KWAIT 10 │
│TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │
│KWAIT 10 │
│DEMO │
└────────────────────────────────────────────────────────────────────────────┘
Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 80
Special keys for 'moving around' the SIMPLE EDITOR screen are:
Left Arrow Key - Move to your left
Right Arrow Key - Move to your right
Ctrl Home - Go to the top, leftmost corner of window
Ctrl End - Go to the bottom, rightmost corner of window
Up Arrow - Move up one line
Down Arrow - Move down one line
PgUp - Page up a full screen
PgDn - Page down a full screen
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end of the file
* F2 - Import text from a text file
* Ctrl W - Save Changes and Exit
* Esc - ABORT Changes and Exit
The margin may exceed the boundaries on the right side of the screen, but
the text is easily accessed using the special keys above...
■ SORT DATABASE
This option takes a database, sorts it, and copies the result into a new
database. The first prompt is for the name of the database you want to sort.
Enter the name, or press Enter on an empty prompt to bring up a window box
containing all databases in the current directory.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DOG.DBF │ 259 │ 09/16/89 │
│CAT.DBF │ 375 │ 09/16/89 │
│CAR.DBF │ 195 │ 09/17/89 │
│BAM.DBF │ 7335 │ 09/16/89 │
│HARP.DBF │ 103 │ 09/17/89 │
│TRAIN.DBF │ 24387 │ 09/17/89 │
│HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└───────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 81
The next prompt is for the name of the database you will be creating with
the sorted data.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: INVNET.DBF │
│ Enter Name of Sorted File: INVNET1.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
The next prompt is for the sort field (limited to 1 field)...
╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: TOM.DBF │
│ Enter Name of Sorted File: TOM1.DBF │
│ Enter the Key Expression: PART │
└───────────────────────────────────────────────────────────────┘
■ TYPE (PRINT) FILE
Prints an ASCII/text file to screen or printer. The first prompt is for
the file name.
┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐
│ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │
│ Press Enter/Return on an empty field to get a current directory listing. │
└────────────────────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 82
The display of the file (any type), is continuous, but can be paused by
any key (except the Enter & Esc keys). Pressing the Enter key will slow the
printing of the file onto the screen. Press Esc to Abort the display... A
sample display:
FUNCKEY...........MISC FUNIQUE...........MISC
FZAP..............MISC GET_PIC1..........MISC
ISDATA............MISC ISDBF.............MISC
MENU_KEY..........MISC MISC..............MISC
OKFILE............MISC PACKIT............MISC
PICKDBF...........MISC PROCLIST..........MISC
SHOW_INS2.........MISC STATLINE2.........MISC
TOG_INS2..........MISC XKEY_CLEAR........MISC
XKEY_NORM.........MISC XMEMO.............MISC
MISC
BKDOOR BROWSEIT CENTER1 COLORSET
DBFUNCT DBFUNCT6 EDITOR FACHOICE
FAPPEND FCOPY2 FDBF1 FDELETE
FERASE FILESZ FILE_UDF FILT
FINDER FINDEX FMAKEDB FMODYDB
FNEW FRECALL FRUN FSCROLL1
FSORT FTYPEIT FUNCKEY FUNIQUE
FZAP GET_PIC1 ISDATA ISDBF
MENU_KEY MISC OKFILE PACKIT
PICKDBF PROCLIST SHOW_INS2 STATLINE2
TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO
PRESS ANY KEY TO CONTINUE...
■ ZAP DATABASE
Totally erase all records in database (forever!). When you want to remove
every record from a database, then use this option. Use with EXTREME CAUTION!
The first prompt is for the file name. Enter the name of the database you are
to 'clean out', or press Enter to select the database from a window
containing all databases in the current directory.
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 83
┌────┐
│ZAP!│
└────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DENVER.DBF │ 259 │ 09/16/89 │
│OHIO.DBF │ 375 │ 09/16/89 │
│NEWYORK.DBF │ 195 │ 09/17/89 │
│MONTANA.DBF │ 7335 │ 09/16/89 │
│SC.DBF │ 259 │ 09/17/89 │
│EARS.DBF │ 103 │ 09/17/89 │
│FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐
│MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │
│CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │
└──────────────┴────────────┴──────────┘───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
You will be prompted one last time as to whether you still want to ZAP
the selected database. Press Y for Yes, N for No...
┌────┐
│ZAP!│
└────┘
┌──────────────────────────────────────────────────────────────────────────┐
│ ZAP TRASH │
│ Are you sure you want to ZAP (remove all records permanently) ? N │
│ │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 84
■ SCREEN FONTS
This option allows EGA or VGA capable computers to set a global font
for use while in the program. Defaults to standard font.
╔═══[ SCREEN FONTS ]═════════════════════════════╗
║ ║
║ Select Font -> Standard (Normal) ║
║ Old English ║
║ Avante Garde ║
║ Bauhaus ║
║ Bodoni ║
║ Esc (Exit) Broadway ║
║ Script I ║
║ Script II ║
║ Calligraphy ║
║ Garamond ║
║ Legend ║
║ Percy ║
║ Park Avenue ║
╚════════════════════════════════════════════════╝
■ SYSTEM
This routine lists system statistics about your computer and optionally
lets you set the date and time.
╔═════════════════════════════════[ SYSTEM ]═════════════════════════════════╗
║ DOS Version: 3.310 ║
║ DOS Memory: 640 ║
║ Free DOS Memory: 48 ║
║ Extended Memory: 0 ║
║ Expanded Memory: 0 ║
║ Parallel Ports: LPT1: ║
║ Serial Ports: COM1: COM2: ║
║ CPU Type: 80386 ║
║ Monitor Type: VGA ║
║ Available Drives: ABCD ║
║ Current Drive: D: ║
║ Volume Name: ║
║ Disk Size: 175,996,928 ║
║ Available Space: 13,254,656 7.53% of Disk Open... ║
║ Disk Clusters: 21,484 ║
║ Cluster Size: 8,192 ║
║ Sectors: 16 ║
║ Sector Size: 512 ║
║ Date: 10/29/91 ║
║ Time: 00:44:30 ║
║ Change Date and/or Time? (Y/N) ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 85
■ REPORT PRINTER PORT
This is the printer port that all your reports will be directed to when
printing to a printer. The default is LPT1.
╔══════════════════════════[ REPORT PRINTER PORT ]═══════════════════════════╗
║ Enter Your Report Printer Port (1,2,3): 1 ║
╚════════════════════════════════════════════════════════════════════════════╝
■ AUTOMATIC DAILY INDEXING
Though not required, it is usually a good idea to reindex all databases
at the beginning of each day. Indexes can easily be corrupted by power
failures and using the MISC routines to add, delete, zap or pack databases.
╔════════════════════════[ AUTOMATIC DAILY INDEXING ]════════════════════════╗
║ If this option is set to Y (YES), then all DAYO Indexes accessed by ║
║ DAYO SC will be recreated once daily. This will occur when the first ║
║ DAYO SC program is run. The default is to recreate all the indexes daily. ║
║ ║
║ Recreate all DAYO SC Indexes? (Y/N) ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
■ COLOR MONITOR
If you have a color monitor (the default setting), then set this option
to Y (Yes).
╔═════════════════════════════[ COLOR MONITOR ]══════════════════════════════╗
║ If you have a color monitor and wish to display colors, then select Y, ║
║ (YES), else select N (NO) for monochrome and others. ║
║ The default is color, low intensity ║
║ ║
║ Do you have a color monitor? (Y/N) ║
╚════════════════════════════════════════════════════════════════════════════╝
■ COLOR INTENSITY
If you want high intensity colors, then set this option to Y (Yes).
╔════════════════════════════[ COLOR INTENSITY ]═════════════════════════════╗
║ Intensity is only applicable with color set to Y. ║
║ It will make your colors brighter... ║
║ ║
║ Set Color Intensity On? (Y/N) ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 86
■ CREDITS
This routine simply displays information about who created DAYO SC...
╔══════════════════[ CREDITS ]════════════════════╗
║ DAYO Support Calls Management System ║
║ Copyright (c) 1992 ║
║ TJS LAB, Inc. ║
║ 5104 North Orange Blossom Trail, #200 ║
║ Orlando, Florida 32810 ║
║ ║
║ Voice: (407) 292-4708 or 291-3960 ║
║ Fax: (407) 295-2171 ║
║ Modem: (407) 292-4921 (2400-8-N-1) ║
║ ║
║ Written Originally for Software Support, Inc. ║
║ Lake Mary, Florida ║
║ ║
║ Author: Tom Johnson ║
║ Publisher: Lorraine Turner ║
║ Testers: Paul Turner and Darren Kelly ║
╚═════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 87
■ REINDEX ALL DATABASES
A complete reindex can be accomplished from the main menu by pressing
Alt F9. Use this option whenever you suspect a bad/corrupted index. Indexes
can easily be corrupted by power failures and using the MISC routines to
add, delete, zap or pack databases.
┌──────────────────────────────────────────────────────────┐
│ Database Name: PIN.DBF │
│ Index Name: PIN.NTX │
│ Index Key: PIN │
│ Number of Records: 161 │
│ ┌──────────────────────────────────────────────────┐ │
│ │████████████████████████ │ │
│ └──────────────────────────────────────────────────┘ │
│ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
└──────────────────────────────────────────────────────────┘
■ AVAILABLE MEMORY
Since this is a big program and requires at least 530k free memory
before startup, this routine was incorporated to help you monitor your
memory (RAM). Accessed from any point in the program by pressing Alt F10...
╔═══════════════════════════════════════╗
║ Available Memory: 55 ║
║ Largest Memory Block: 29 ║
║ Available RUN Memory: 28 ║
╚═══════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 88
■ HELP SCREENS
While in the browse screens, some of the option windows, and in the
SIMPLE EDITOR, pressing the F1 key, will display a help screen.
BROWSE help:
┌───────────────────────[ DAYOSC HELP: DBEDIT, 0, ]─────────────────────────┐
│ │
│- Special keys for 'moving around' the BROWSE screen are: │
│ │
│ Left Arrow Key - Move to next field to your left │
│ Right Arrow Key - Move to next field to your right │
│ Ctrl Home - Go to the leftmost field │
│ Ctrl End - Go to the rightmost field (on the end of the record)│
│ Up Arrow - Move highlight to the previous record │
│ Down Arrow - Move highlight to the next record │
│ PgUp - Page up a full screen of records │
│ PgDn - Page down a full screen of records │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end or last record of the file │
│ Ctrl N - Add a record (where applicable) │
│ Ctrl U - Delete a record (where applicable) │
│ F5,F6,F7 - To seek/find a record based upon the active index │
│ Esc - Exit the current operation │
│ │
│ Remember that there are many more fields to the right of the screen. │
│ Press the right arrow key to view them... │
└────────────────────────────────────────────────────────────────────────────┘
Option Box Help:
┌────────────────────────[ DAYOSC HELP: ACHOICE, 0, ]───────────────────────┐
│ │
│ │
│ │
│ │
│ - Special keys for 'moving around' the Option Box are: │
│ │
│ Up Arrow - Move up one option │
│ Down Arrow - Move down one option │
│ PgUp - Page up multiple records │
│ PgDn - Page down multiple records │
│ Esc - ABORT and Exit │
│ │
│ │
│ After highlighting the option you desire, press Enter... │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 89
Editor help:
┌───────────────────────[ DAYOSC HELP: MEMOEDIT, 0, ]───────────────────────┐
│ │
│ - Special keys for 'moving around' the EDITOR screen are: │
│ │
│ Left Arrow Key - Move to your left │
│ Right Arrow Key - Move to your right │
│ Ctrl Home - Go to the top, leftmost corner of window │
│ Ctrl End - Go to the bottom, rightmost corner of window │
│ Up Arrow - Move up one line │
│ Down Arrow - Move down one line │
│ PgUp - Page up a full screen │
│ PgDn - Page down a full screen │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end of the file │
│ Ctrl W - SAVE Changes and Exit │
│ Esc - ABORT Changes and Exit │
│ F2 - Import another text file into your document │
│ │
│ The margin may exceed the boundaries on the right side of the screen, │
│ but the text is easily accessed using the special keys above... │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
■ EXPANDED HELP
After Version 1.3, expanded help routines were added to all DAYO modules.
At almost all prompts and menus you can press F1 for help. Help can be a
function key message as displayed on previous page, a message that you have
created (user defined & inputted), or the ability to read the documentation
on the screen (saves paper).
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 90
■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
If you press F1 and no user defined & inputted message exists for that
section of the program you are currently in you will receive a message to
this effect, and then a blank/empty screen.
The editing keys for this option are the same as for the Simple Editor
(previous page).
┌──────[ DAYO HELP Called by Program: DAYOSC Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ │
│ │
│ ╔════════════════════════════════════════════════════════╗ │
│ ║ No Online Help Messages Exist for this prompt... ║ │
│ ║ ║ │
│ ║ You can type in any help message you wish, or ║ │
│ ║ press F1 to view the document for DAYOSC. ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ Press any key to continue... ║ │
│ ╚════════════════════════════════════════════════════════╝ │
│ │
│ │
├───────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │
└───────────────────────────────────────────────────────────────────────────┘
If you wish to input anything at this point, just type whatever you
wish, remembering to press Ctrl W to save all changes. Pressing Esc will
not save ANY changes ( all effort you put into writing a help message will
be lost! ).
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 91
┌───────[ DAYO HELP Called by Program: DAYOSC Variable: OPT ]───────┐
│ │
│ │
│ │
│ Type in anything you wish about this portion of the program! │
│ │
│ The length of this file can be many pages... │
│ │
│ Be sure to press Ctrl W to save any changes/additions you make to this │
│ screen. │
│ │
│ │
│ │
│ │
│ │
│ │
├────────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │
└────────────────────────────────────────────────────────────────────────────┘
■ VIEW DOCUMENTATION ON SCREEN
To view the documentation for the module you are in, it must first exist
in the current directory. Document files are named the same as the module,
and have the extension of '.DOC', ie: DAYOSC.DOC, DAYOPOS.DOC, DAYOPAY.DOC.
Press F1 in the User Defined & Inputted Help Message screen to display the
document (user manual). The special keys in this option are displayed in the
Help Screen (press F1 again) for this option:
╔══════════════════════════════════════════════════════════════════════════╗
║ While viewing the document for DAYO SC the keyboard is configured ║
║ as followed: ║
║ ║
║ Esc Exit ║
║ F5 Find a string. This search is not case sensitive ║
║ Examples: Page 50 ║
║ INTRODUCTION ║
║ REPORTS ║
║ Home Return to the beginning of the document ║
║ End Go to the bottom of the document ║
║ PgUp Page up ║
║ ║
║ Any other key moves acts like PgDn (page down) ║
║ ║
║ Press any key to continue... ║
╚══════════════════════════════════════════════════════════════════════════╝
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 92
■ DATABASE STRUCTURES
Structure for database: CALLOG.CFG
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 PASSWORD Character 7
2 LOGIN Character 30
3 NAME Character 30
4 DATE Date 8
5 ACTIVE Logical 1
6 SDATE Date 8
7 STIME Character 8
8 STATUS Logical 1
9 EXCLUDE Character 15
────────── ─────
Total 109
Structure for database: CAT1.DBF
1 CATEGORY Character 39
────────── ─────
Total 40
Structure for database: CAT2.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 CATEGORY Character 39
────────── ─────
Total 40
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 93
Structure for database: CODES.CFG
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 CODE_0 Character 1
2 CODE_1 Character 1
3 CODE_2 Character 1
4 CODE_3 Character 1
5 CODE_4 Character 1
6 CODE_5 Character 1
7 CODE_6 Character 1
8 CODE_7 Character 1
9 CODE_8 Character 1
10 CODE_9 Character 1
────────── ─────
Total 11
Structure for database: CUSTMEMO.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 CUSTOMER Numeric 6
2 NOTES Memo 10
────────── ─────
Total 17
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 94
Structure for database: CUSTOMER.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 CUSTOMER Numeric 6
2 NAME Character 30
3 ATTN Character 30
4 ADDR1 Character 30
5 ADDR2 Character 30
6 CITY Character 22
7 STATE Character 2
8 ZIP Character 10
9 PHONE Character 14
10 SHIPNAME Character 30
11 SHIPADDR1 Character 30
12 SHIPADDR2 Character 30
13 SHIPCITY Character 22
14 SHIPSTATE Character 2
15 SHIPZIP Character 10
16 SHIPPHONE Character 14
17 SALESPER Character 3
18 TAXRATE Numeric 7 5
19 TAXRATE2 Numeric 7 5
20 TERMS Character 20
21 SHIPPER Character 20
22 FOB Character 20
23 DATE Date 8
24 LASTDATE Date 8
25 TYPE Character 3
26 CLASS Character 3
27 PBM Numeric 6 3
28 PBL Numeric 6 3
29 SALESPTD Numeric 10 2
30 SALESYTD Numeric 10 2
31 DUE Numeric 10 2
32 PAID_PURC Numeric 10 2
33 LIMIT Numeric 10 2
34 FAX Character 14
35 PRICEX Numeric 1
36 ACTIVE Logical 1
37 CREDCARD Character 20
38 TAXCODE Character 3
────────── ─────
Total 513
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 95
Structure for database: DAYOCUST.CFG
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 CUSTOMER Numeric 6
────────── ─────
Total 7
Structure for database: HISTORY.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 REFERENCE Numeric 8
2 PIN Character 11
3 CUSTOMER Numeric 6
4 CATEGORY1 Character 30
5 CATEGORY2 Character 30
6 RESOLUTION Character 30
7 COMMENTS Character 50
8 PHONE Character 20
9 DATE Date 8
10 TIME Character 8
11 ENDDATE Date 8
12 ENDTIME Character 8
13 TECHNICIAN Character 30
14 CLOSEDBY Character 30
15 OPEN Logical 1
16 NOTES Memo 10
────────── ─────
Total 289
Structure for database: INCIDENT.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 REFERENCE Numeric 8
2 PIN Character 11
3 CUSTOMER Numeric 6
4 CATEGORY1 Character 30
5 CATEGORY2 Character 30
6 RESOLUTION Character 30
7 COMMENTS Character 50
8 PHONE Character 20
9 DATE Date 8
10 TIME Character 8
11 ENDDATE Date 8
12 ENDTIME Character 8
13 TECHNICIAN Character 30
14 CLOSEDBY Character 30
15 OPEN Logical 1
16 NOTES Memo 10
────────── ─────
Total 289
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 96
Structure for database: LOG.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 PIN Character 11
2 CATEGORY1 Character 30
3 CATEGORY2 Character 30
4 PHONE Character 20
5 DATE Date 8
6 TIME Character 8
7 CLOSED Logical 1
────────── ─────
Total 109
Structure for database: MENU.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 FILENAME Character 12
2 DESC Character 30
3 LASTDATE Date 8
4 LASTTIME Character 8
5 RUNS Numeric 7
6 LOCATION Character 60
7 DATE Date 8
8 LASTUSER Character 30
────────── ─────
Total 164
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 97
Structure for database: PDRIVER.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 NAME Character 30
2 LINEFEED Character 30
3 NORMAL Character 50
4 SMALL Character 50
5 BOLDON Character 50
6 BOLDOFF Character 50
7 _6LPI Character 50
8 _8LPI Character 50
9 PORTRAIT Character 50
10 LANDSCAPE Character 50
11 RESET Character 50
12 SPEC_STR1 Character 50
13 SPEC_STR2 Character 50
14 SPEC_STR3 Character 50
15 SPEC_STR4 Character 50
16 SPEC_STR5 Character 50
17 RUN_CMD Character 50
────────── ─────
Total 811
Structure for database: PIN.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 PIN Character 11
2 CUSTOMER Numeric 6
3 FNAME Character 15
4 LNAME Character 15
5 ADDRESS1 Character 30
6 ADDRESS2 Character 30
7 CITY Character 22
8 STATE Character 2
9 ZIP Character 10
10 PHONE1 Character 20
11 PHONE2 Character 20
12 DOB Date 8
13 SSN Character 11
14 DATE Date 8
15 TIME Character 8
16 ENDDATE Date 8
17 CALLS Numeric 5
18 LASTCAT1 Character 30
19 LASTCAT2 Character 30
20 LASTRESOLU Character 30
21 LASTDATE Date 8
22 LASTTIME Character 8
────────── ─────
Total 336
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 98
Structure for database: PINMEMO.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 PIN Character 11
2 NOTES Memo 10
────────── ─────
Total 22
Structure for database: REFER.CFG
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 REFERENCE Numeric 8
────────── ─────
Total 9
Structure for database: RESOLUTE.DBF
Field Field name Type Width Dec
───── ────────── ───────── ───── ───
1 RESOLUTION Character 30
────────── ─────
Total 31
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 99
■ DATA DICTIONARY
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
ACTIVE L 1 0 CALLOG.CFG Flag field to designate password or
user as being active or not
CUSTOMER.DBF Flag field to designate customer as
being active or not. Not used by
DAYO SC
ADDR1 C 30 0 CUSTOMER.DBF Line 1 of the customer's address
ADDR2 C 30 0 CUSTOMER.DBF Line 2 of the customer's address
ADDRESS1 C 30 0 PIN.DBF Line 1 of the PIN/Customer's
address
ADDRESS2 C 30 0 PIN.DBF Line 2 of the PIN/Customer's
address
ATTN C 30 0 CUSTOMER.DBF Contact or Attention name
BOLDOFF C 50 0 PDRIVER.DBF Printer code that sets up printer
to turn off BOLD
BOLDON C 50 0 PDRIVER.DBF Printer code that sets up printer
to turn on BOLD
CALLS N 5 0 PIN.DBF Number of support calls/incidents
logged by the PIN/Customer
CATEGORY C 39 0 CAT2.DBF Category/Problem code
CAT1.DBF
CATEGORY1 C 30 0 LOG.DBF 1st category/problem code
INCIDENT.DBF
HISTORY.DBF
CATEGORY2 C 30 0 INCIDENT.DBF 2nd category/problem code
HISTORY.DBF
LOG.DBF
CITY C 22 0 PIN.DBF City address
CUSTOMER.DBF
CLASS C 3 0 CUSTOMER.DBF Class code field, not used by
DAYO SC
CLOSED L 1 0 LOG.DBF Flag field that designated VRU
database record as being moved
into the OPEN database or not
CLOSEDBY C 30 0 INCIDENT.DBF Name of user/technician that
HISTORY.DBF closed the call/incident record
CODE_0 C 1 0 CODES.CFG Serial number conversion of '0'
CODE_1 C 1 0 CODES.CFG Serial number conversion of '1'
CODE_2 C 1 0 CODES.CFG Serial number conversion of '2'
CODE_3 C 1 0 CODES.CFG Serial number conversion of '3'
CODE_4 C 1 0 CODES.CFG Serial number conversion of '4'
CODE_5 C 1 0 CODES.CFG Serial number conversion of '5'
CODE_6 C 1 0 CODES.CFG Serial number conversion of '6'
CODE_7 C 1 0 CODES.CFG Serial number conversion of '7'
CODE_8 C 1 0 CODES.CFG Serial number conversion of '8'
CODE_9 C 1 0 CODES.CFG Serial number conversion of '9'
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 100
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
COMMENTS C 50 0 HISTORY.DBF Comments/brief note about the
INCIDENT.DBF support call/incident
CREDCARD C 20 0 CUSTOMER.DBF Credit card number, not used by
DAYO SC
CUSTOMER N 6 0 CUSTOMER.DBF Customer number
PIN.DBF
DAYOCUST.CFG
CUSTMEMO.DBF
HISTORY.DBF
INCIDENT.DBF
DATE D 8 0 CUSTOMER.DBF Date record was created
LOG.DBF
INCIDENT.DBF
HISTORY.DBF
PIN.DBF
MENU.DBF
CALLOG.CFG
DESC C 30 0 MENU.DBF Description of an external program
DOB D 8 0 PIN.DBF Date of birth of PIN/Customer
DUE N 10 2 CUSTOMER.DBF Amount due by the customer, not
used by DAYO SC
ENDDATE D 8 0 HISTORY.DBF Date that call/incident was closed
INCIDENT.DBF
PIN.DBF Date that support contract ends
ENDTIME C 8 0 HISTORY.DBF Time that call/incident was closed
INCIDENT.DBF
EXCLUDE C 15 0 CALLOG.CFG Field contains the excluded main
menu options. Used with passwords
FAX C 14 0 CUSTOMER.DBF Customer's FAX number
FILENAME C 12 0 MENU.DBF File name of external menu option
FNAME C 15 0 PIN.DBF First name
FOB C 20 0 CUSTOMER.DBF Freight on board code/description
LANDSCAPE C 50 0 PDRIVER.DBF Printer code that sets up an HP
Laser printer to print sideways
LASTCAT1 C 30 0 PIN.DBF Last 1st category/problem that a
PIN had
LASTCAT2 C 30 0 PIN.DBF Last 2nd category/problem that a
PIN had
LASTDATE D 8 0 PIN.DBF Last date a PIN had a problem
MENU.DBF Last date an external program was
run
CUSTOMER.DBF Last date accounting accessed the
customer record
LASTRESOLU C 30 0 PIN.DBF Last resolution code that a PIN had
LASTTIME C 8 0 PIN.DBF Last time a PIN had a problem
MENU.DBF Last time an external program was
run
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 101
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
LASTUSER C 30 0 MENU.DBF Last user/technician to run an
external program
LIMIT N 10 2 CUSTOMER.DBF Customer credit limit, not used by
DAYO SC
LINEFEED C 30 0 PDRIVER.DBF Printer code that prints a single
line feed
LNAME C 15 0 PIN.DBF Last name
LOCATION C 60 0 MENU.DBF Location/Drive/Directory of an
external program
LOGIN C 30 0 CALLOG.CFG Login name of user/technician
NAME C 30 0 CUSTOMER.DBF Customer/Company name
CALLOG.CFG User/Techician name
PDRIVER.DBF Name of printer
NORMAL C 50 0 PDRIVER.DBF Printer code to print normal size
(10 CPI) characters
NOTES M 10 0 INCIDENT.DBF Call/Incident notes
HISTORY.DBF
CUSTMEMO.DBF Customer notes
PINMEMO.DBF PIN notes
OPEN L 1 0 HISTORY.DBF Flag field that designates a call
INCIDENT.DBF or incident as being open or not
PAID_PURC N 10 2 CUSTOMER.DBF Amount paid by a customer, not used
by DAYO SC
PASSWORD C 7 0 CALLOG.CFG Encrypted password
PBL N 6 3 CUSTOMER.DBF N/A
PBM N 6 3 CUSTOMER.DBF N/A
PHONE C 20 0 LOG.DBF Telephone number
HISTORY.DBF
INCIDENT.DBF
PHONE C 14 0 CUSTOMER.DBF Telephone number
PHONE1 C 20 0 PIN.DBF PIN's 1st Telephone number
PHONE2 C 20 0 PIN.DBF PIN's 2nd Telephone number
PIN C 11 0 INCIDENT.DBF Personal Identification Number
LOG.DBF
PINMEMO.DBF
HISTORY.DBF
PIN.DBF
PORTRAIT C 50 0 PDRIVER.DBF Printer code that make an HP Laser
printer print upright (normal)
PRICEX N 1 0 CUSTOMER.DBF N/A
REFERENCE N 8 0 HISTORY.DBF Reference number of a support call
INCIDENT.DBF or incident
REFER.CFG
RESET C 50 0 PDRIVER.DBF Printer code that resets the
printer back to its default
settings
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 102
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
RESOLUTION C 30 0 RESOLUTE.DBF Resolution code. This is a code
HISTORY.DBF that represents what you did to
INCIDENT.DBF solve the problem
RUNS N 7 0 MENU.DBF Number of times an external program
was run/selected
RUN_CMD C 50 0 PDRIVER.DBF Run a DOS command (ie: spool) while
in the Printer Setup/Driver routine
SALESPER C 3 0 CUSTOMER.DBF Sales person code assigned to the
customer. Not used by DAYO SC
SALESPTD N 10 2 CUSTOMER.DBF Customer sales period to date
SALESYTD N 10 2 CUSTOMER.DBF Customer sales year to date
SDATE D 8 0 CALLOG.CFG Start date that user/technician
started running DAYO SC
SHIPADDR1 C 30 0 CUSTOMER.DBF N/A
SHIPADDR2 C 30 0 CUSTOMER.DBF N/A
SHIPCITY C 22 0 CUSTOMER.DBF N/A
SHIPNAME C 30 0 CUSTOMER.DBF N/A
SHIPPER C 20 0 CUSTOMER.DBF N/A
SHIPPHONE C 14 0 CUSTOMER.DBF N/A
SHIPSTATE C 2 0 CUSTOMER.DBF N/A
SHIPZIP C 10 0 CUSTOMER.DBF N/A
SMALL C 50 0 PDRIVER.DBF Printer code that sets up printer
to print small characters
SPEC_STR1 C 50 0 PDRIVER.DBF Special/User defined printer code
SPEC_STR2 C 50 0 PDRIVER.DBF Special/User defined printer code
SPEC_STR3 C 50 0 PDRIVER.DBF Special/User defined printer code
SPEC_STR4 C 50 0 PDRIVER.DBF Special/User defined printer code
SPEC_STR5 C 50 0 PDRIVER.DBF Special/User defined printer code
SSN C 11 0 PIN.DBF Social Security Number of PIN
STATE C 2 0 PIN.DBF State address, ie: FL, CA, GA
CUSTOMER.DBF
STATUS L 1 0 CALLOG.CFG Flag field to designate whether
a user/technician is currently in
the program or not
STIME C 8 0 CALLOG.CFG Start time that user/technician
started running DAYO SC
TAXCODE C 3 0 CUSTOMER.DBF N/A
TAXRATE N 7 5 CUSTOMER.DBF N/A
TAXRATE2 N 7 5 CUSTOMER.DBF N/A
TECHNICIAN C 30 0 INCIDENT.DBF Name of your technician that
HISTORY.DBF initiated the call/incident record
TERMS C 20 0 CUSTOMER.DBF N/A
TIME C 8 0 INCIDENT.DBF Time record was created
HISTORY.DBF
LOG.DBF
PIN.DBF
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 103
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
TYPE C 3 0 CUSTOMER.DBF N/A
ZIP C 10 0 CUSTOMER.DBF Zip code
PIN.DBF
_6LPI C 50 0 PDRIVER.DBF Printer code that sets up printer
to print 6 lines per inch
(Usually the default)
_8LPI C 50 0 PDRIVER.DBF Printer code that sets up printer
to print 8 lines per inch
DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 104
■ TJS 'COMPUTER' LAB INC
TJS LAB is an association of programmers and technicians that produce
customized, multiuser software for the PC based network (ie: Novell and
others). Our specialties include Inventory Control, PC Communications/EDI,
Management, Reports (standard and graphic), Data Conversions, and
Accounting (A/R, A/P).
A unique feature of TJS LAB is that our software is by default, multiuser.
'Standalone' applications are the exception! All our applications are
written in Clipper, Basic, or C (preferably Basic or Clipper). We will
license all our application source codes. We produce applications that work,
are easy to use, and are inexpensive!
Want a change?
Want an enhancement!
Want a completely new product/application?
Want to make your idea a reality?
Custom/contract programming, by TJS LAB, and our associates is available.
Standard rate is $50.00 per hour (our sites). Guaranteed quality and timely
work is our number one policy.
Write us at:
TJS LAB
PO Box 585366
Orlando, Florida 32858-5366
Or call us (9:00 am - 11:00 pm):
(407) 291-3960
* Note that TJS LAB, nor any of the associates accept/take any support
calls for unregistered products.
